Simply put [From] and [To] (complete with the square brackets) as the
criteria for your query.

Note that if your date field has times associated with it (such as it will
if you used the Now() function to populate the field, rather than the Date()
function), you'll probably want DateAdd("d", 1, [To])

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Ralph Malph" wrote in message
...
I have a query that that prints a bunch of payment records. I need to
beable to print just the records with in a specific time frame. I can
do it if I hard code the date range into the query, but I want it to
ask me for the start date and end date, so I need a criteria
expression that will ask for "from" and "to" dates and then select
records that fall within that date span for access 2000 please. Thanks
for helping in advance.

Ralph Malph