REQ: Need Criteria expression that will ask for "from" and "to" dates and then select records that f

R

Ralph Malph

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
 
D

Douglas J. Steele

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])
 
R

Ralph Malph

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])
Click to expand...
 
Top