Multiple filter

clembo

I need to apply multiple filter on recordset.
This is a sample:

I have a custom table with two field: [Start date], [End date]

I need to get all record in my report that apply date range on two fields (Start date, End date):

Date range: 01/01/2012 - 31/03/2012

Records in tabel are:

Start date End date
01/02/2012 31/12/2012
01/03/2012 30/04/2012
01/04/2012 31/05/2012

There is a way to apply with one filter all filers

ufuk

Date filter in filter command works as AND operator. If you want to use it as OR you have to loop through records.