Month Query

  • Thread starter Thread starter gregork
  • Start date Start date
G

gregork

I have a table for orders produced. I have run a query off this table that
groups the dates by month (February 2005 format). Now I want to have a
prompt in the criteria so that I get prompted to enter a month in the
format:February 2005.
How do I do this?

GK
 
You would be better off to put these expressions in your query:
OrderYear:Year([OrderDate])
OrderMonth:Month([OrderDate])
Set the criteria for OrderYear as:
[Enter Order Year]
Set the criteria for OrderMonth as:
[Enter Order Month, ex. 2 for February]
 
Thanks for the advice

cheers
GK


PC Datasheet said:
You would be better off to put these expressions in your query:
OrderYear:Year([OrderDate])
OrderMonth:Month([OrderDate])
Set the criteria for OrderYear as:
[Enter Order Year]
Set the criteria for OrderMonth as:
[Enter Order Month, ex. 2 for February]

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



gregork said:
I have a table for orders produced. I have run a query off this table that
groups the dates by month (February 2005 format). Now I want to have a
prompt in the criteria so that I get prompted to enter a month in the
format:February 2005.
How do I do this?

GK
Click to expand...
Click to expand...
 
Back
Top