Unanswered: Dates from textboxes to query - Wildcards?
I am trying to sort a report by date, but I cannot include the day in the sort, just the month and the year.
I tried using a form with two textboxes, one for the month and one for the date, and added them to a query. the finished result produced 9/##/02 in the query if you picked september 2002. (I thought that since # is a number wildcard, it might select all dates from that month)
Access comes up with an error saying the expression is too complex.
Is there a way I can sort just by month and year and ignore the day?