Between Dates query.

[serino64]

I having trouble with my Date Query.

When the user enters a “Beginnning Date” and “Ending Date” the query should display the required info and the dates the user specified. My query does provide me with the correct info but is not displaying the dates I specified.

FIELD: DATE
TABLE: SALES
TOTAL: FIRST
SORT DECSENDING
SHOW: CHECKED
CRITERIA: >=[Enter Beginning date for totals]

FIELD: DATE
TABLE: SALES
TOTAL: LAST
SORT DECSENDING
SHOW: CHECKED
CRITERIA: >=[Enter Ending date for totals]

The Problem with my query is when I enter a date range; lets say 1 June 99 and 1 May 03, the dates will not show up as I specified. If I enter a Date range within the current year there is no problem.

Any assistance is appreciated.

 

[cheiboy]

Try this in the critera of the date field(s):

[Enter Start Date] and [Enter End Date]

 

[serino64]

cheiboy, Thanks for your reply.

I took your advise and it worked. I think I am on the right track now. I added the following to the query:

Criteria: Between [Enter Start Date] And [Enter End Date]


How do I display the Start Date and End Date on my form?