Query from/to dates

  • Thread starter Thread starter Carla
  • Start date Start date
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!
 
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!
 
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.
 
Back
Top