How do I do a parameter query on =month([Form])

M

MTstraw

I need to pull the month out of a birth date (01-Jan-85) and change it to
read either Jan or January. Once this is done I than need to do a parameter
query to show only those birthdays listed in January. When I get this
complete I get an error message or no data at all. How can this be fixed.
 
O

Ofer Cohen

To get the month you can use

format(DateFieldName,"mmmm")

In the report use a parameter query that ask the user to select a month

Select * From TableName Where format(DateFieldName,"mmmm") = [Please enter a
month]
===========================
I rather create a form where the user can select a month, and then use a
button to open a report.
 
Top