Unless the Status field contains a date then searching against it for a
date range makes no sense at all. Similar to the following
Sir, what kind of fruit would you like? Response: Honda
It sounds to me like you need to search for Status = "Rejected" and
SomeDateField between [Period Starts] and [Period Ends]
Whoops! perhaps I misread your posting.
Try defining the parameters (and naming them).
Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2
Optionally surround the parameters with CDate to make sure Access
understands that you are inputting dates
SomeDateField between CDate([Period Starts]) and CDate([Period Ends])
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
Hi, I have a table that details requests and want to be able to pull up a
report by date range where the status is "Rejected" I have the date range
search as Between [ ] and [ ] and have put under status "Rejected". When
I run the query I am asked for date range, I do not get any Rejected
requests though.