Query from/to dates

C

Carla

I need to know how to get a query to prompt me to answer
the question of From what date? and secondly To what
date?.

Thanks for any help!
 
R

Rick B

Add the date you wish to evaluate to your query in design view. In the
criteria field for your date column put something like...


between [EnterStartDate] and [EnterEndDate]


Rick B

I need to know how to get a query to prompt me to answer
the question of From what date? and secondly To what
date?.

Thanks for any help!
 
A

ack

an easy way is to just use [From Date] and [To Date] in
the selection criteria, and if it can't find those fields,
it will prompt for them.
 
Top