F
Frank
I have query built on a table. The table has fields as follows:
One date field formatted as "Short Date." - [Date]
Two yes/no fields - [Name1] and [Name2]
The query date field criteria is: Between [start date] and [end date]
The criteria for[Name1] is Yes
No under the Or function
The criteria for[Name2] is No
Yes under the Or function
When I run the query, it does not return the correct number of records
between the entered dates. How do I resolve this???
Any assistance is greatly appreciated.
One date field formatted as "Short Date." - [Date]
Two yes/no fields - [Name1] and [Name2]
The query date field criteria is: Between [start date] and [end date]
The criteria for[Name1] is Yes
No under the Or function
The criteria for[Name2] is No
Yes under the Or function
When I run the query, it does not return the correct number of records
between the entered dates. How do I resolve this???
Any assistance is greatly appreciated.