Having problem using form field as query criteria

[ksolomon]

Hi,
I have a form that I have 2 dates on. I am trying to use these dates as criteria for a query:
Between [Forms]![Form Name]![Start Date] AND
[Forms]![Form Name]![End Date]

The query is running as if that criteria statement is not there and it includes dates that are not between the start and end.

Any ideas?

 

[WildHare]

Are your date guys on the form defined as DATE types? If they're default text guys, it may not make the passing of the data correct.

Otherwise, this should be very easy, as I've done it a 1x10^6 times...

JMH

If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm