Qbf

[Dazza666]

Hi,

I have a query by form set up, the criteria for my StartDate field is

>=[FORMS]![STATISTICS]![txtSTARTDATE] AND <=[FORMS]![STATISTICS]![txtEndDate]

it throws up the 'too complex to be evaluated message'

i've tried using the BETWEEN clause with no luck,

it works fine if i only specify one criteria i.e. >=[FORMS]![STATISTICS]![txtSTARTDATE]

the thing is i'm sure i've had this working before on an older databse (that i can't find)

can someone confirm what i'm doing wrong or whether i can do this at all.

thanks

 

[Dazza666]

Hi,

I have a query by form set up, the criteria for my StartDate field is

>=[FORMS]![STATISTICS]![txtSTARTDATE] AND <=[FORMS]![STATISTICS]![txtEndDate]

it throws up the 'too complex to be evaluated message'

i've tried using the BETWEEN clause with no luck,

it works fine if i only specify one criteria i.e. >=[FORMS]![STATISTICS]![txtSTARTDATE]

the thing is i'm sure i've had this working before on an older databse (that i can't find)

can someone confirm what i'm doing wrong or whether i can do this at all.

thanks

nevermind,

it works after i retyped [txtEndDate]

weird though because i know there were no gaps because of the brackets, and there were no typos

UPDATE!

it's because I had the 31 september in the endDate box (imbecile)


thanks anyway

 

[khawar]

Use this instead

Between [FORMS]![STATISTICS]![txtSTARTDATE] AND [FORMS]![STATISTICS]![txtEndDate]