Month Query restrict records

[geebanga88]

HI i want to create a month query that restricts the records by a month given that is inputed by a user from a form. There is an attribute in the relation called date which should only match the month date given by the user. What clause would i enter to get this restriction? i believe it has somthing to do with a date function? but im still unfamilar with it.

I would also like to know which what is the best way to ask the user for a month in the form. My approach is to have numerical values in a list box or is ther a better way to do this?

Table Schema:
Date
PatientNo
ProviderNo

[Rabbit]

I usually use a combo box but a listbox works as well. As for the criteria, you don't care about the year? Just use the Month() function then to return the month value of a Date.

[geebanga88]

I usually use a combo box but a listbox works as well. As for the criteria, you don't care about the year? Just use the Month() function then to return the month value of a Date.

Yer i will need year as wel do get each month of each year.
Just wonderin how would you do that in a query?
Somthing like

SELECT PatientAccount.Date
FROM PatientAccount; 
WHERE PatientAccount.Date = [forms]![txtDateForm]![Year(),Month()] 

Not sure if thats right

[Rabbit]

You're looking for:

Year(PatientAccount.Date) = [forms]![txtDateForm]![txtYear] AND Month(PatientAccount.Date) = [forms]![txtDateForm]![txtMonth]