Multiple filter

clembo
clembo Member Posts: 122
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

Comments

  • ufuk
    ufuk Member Posts: 514
    Date filter in filter command works as AND operator. If you want to use it as OR you have to loop through records.
    Ufuk Asci
    Pargesoft