Hey guys,
I new to access. I would like to specify two dates and have my database display all the strings within those two dates.
Any ideas on how this can be done???
Hey guys,
I new to access. I would like to specify two dates and have my database display all the strings within those two dates.
Any ideas on how this can be done???
In a query set the criteria for the date field to be:
Between #[What is first date?]# and #[What is last date?]#
When you run the query you will be prompted for the first date and the last date...your results will be all the data between these dates.
Thanks "jfgambit"
Your suggestion worked like a charm. Now I just have to find a way of turning the results into a report.
Thanks everyone for the help.