I have a very simple query that is giving me real trouble. I have a table, "Invoicing" which records all data about individual invoices. Within this table, I have a field for date of issue.
I want to run a query that shows all invoices in the current month, so when I run the associated report at any time, it will show me what has been invoiced for the current month.
I have tried the Month(Now()) and Year(Now()) functions but I cannot get it to work. Some help with this simple question would be appreciated. I have searched all over and cannot find something else here that answers my exact question.
Thanks