Could someone please advise whether it's possible to use a parameter in order to get a query to return specific results from a date field?
I.E. If we have Invoice Dates for 01/03/04, 02/03/04, and 01/04/04, we just want to see what invoices were sent out in March. Therefore, to get the query to return just Invoices for March, we would use criteria such as:
*/[Enter the Month]/04
From the Access Help File, it appears that these need to be joined with ampersands, thusly:
LIKE "*" & [Enter any character to search by: ] & "*"
I've tried to enter my Query in this format (IE: LIKE "*" & [Enter the month] & "04"), but it doesn't work.
I'm guessing it's not possible to enter a Parameter in a Date Field.
P.S. i tried using # symbols, but that didn't work either.
Thanks for any help you can provide.