Hi There, I am trying to create a query that shows the records that fall within the month of a specified date. For example if I selected the date 10th May 2017 in my date picker text box txtMonth how can I get the query to return any matching record with a date in May please.
I have tried the following in the criteria box but unfortunately doesn't work:
Any help would be very appreciated.
Many thanks,
Dom
I have tried the following in the criteria box but unfortunately doesn't work:
Code:
Month([Forms]![frmReportLookup]![txtMonth])
Many thanks,
Dom