Date query

  • Thread starter Thread starter rokjock
  • Start date Start date
R

rokjock

I have a table that keeps track of interview data (dates times
locationsetc). Could anyone tell me how I could build a simple query that
will allow me to view the data for a single month. I have figured out how
to get it to show me a specific date but what if I wanted to get a ranfe of
dates and view all of the data in between (like a pop up box that asks to
"enter the date range". Is this possible? Thank you very much for your
help!!!
 
A simple parameter query would be something like the following.


Field: InterviewDate
Table: YourTable
Criteria: Between [Enter start date] AND [Enter End Date]

Hope this is enough to explain the concept to you. Try looking up "Parameter
Query" in the online help for more details.
 
Worked like a charm!!! Thank you very much!
John Spencer (MVP) said:
A simple parameter query would be something like the following.


Field: InterviewDate
Table: YourTable
Criteria: Between [Enter start date] AND [Enter End Date]

Hope this is enough to explain the concept to you. Try looking up "Parameter
Query" in the online help for more details.
I have a table that keeps track of interview data (dates times
locationsetc). Could anyone tell me how I could build a simple query that
will allow me to view the data for a single month. I have figured out how
to get it to show me a specific date but what if I wanted to get a ranfe of
dates and view all of the data in between (like a pop up box that asks to
"enter the date range". Is this possible? Thank you very much for your
help!!!
Click to expand...
Click to expand...
 
Back
Top