Wild Cards for Dates?

[janelgirl]

I am new to access, so please speak softly, and forgive my ignorance.



Is there such a thing as a wild card for dates? For example, in a query, using the short date format, if I wanted to look for any record that was ever recorded in any year in October, how would I do that? In other words, my query would return October 1, 1999 and October 14, 2005 and October 23, 2099.

Here's the rub: I will need to use this over and over again, sometimes I will use it for the actual day, month or year. It will change from query to query depending on the info that I am searching, and I will write expressions as well. I think that wild cards would be the best way to accomplish this, but no matter what I use, I can't seem to get Access to even run the query.

Any help is appreciated. TIA

[orange]

What have you tried?


Pattern is

SELECT * FROM YourTableName WHERE Day(yourDateField) = 1 to 31 ( 30 or 28 rules apply)
SELECT * FROM YourTableName WHERE Month(yourDateField) = 1 to 12
SELECT * FROM YourTableName WHERE Year(yourDateField) =

You could AND criteria
You could use a BETWEEN

[janelgirl]

Select * from InvoicesQuery where day(ReceivedDate) = 1 - 31

This is what i put in from your formula, but it is not working. I tried putting quotation marks around InvoicesQuery, but that did not help. Since I am so new to access, I am sure that there is something simple that I am missing here. Should I replace the asterisk with specific info? Thanks!

[orange]

This would be the SQL for your query to get InvoiceInfo for a specific Day in any Month in any Year

Select * from InvoicesQuery where day(ReceivedDate) = 21

You have to put the day, such as 21 for day 21 of any Month in any Year.

For Month say March (month 3)
Select * from InvoicesQuery where Month(ReceivedDate) = 3

[janelgirl]

That worked perfectly!! Thank you VERY much!! :-)