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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
Duplicate prompts in crosstab query and subsequent report 1
Query Question 1
Crosstab Query based on Query 4
Dcount returning no results!!! 0
Update query should not fire if prompt is null 1
Need help creating query involving dates 3
Prompting for date range twice 3

Back
Top