Hello all,
This should be very simple but for some reason I am missing something. I have a database that I have been using for a long time and created many different queries in it but this one I just can't get to work, I am sure it is something very simple I am overlooking.
The attached database has 1 table, 1 form and 1 report from the large one I created and use daily. I want to be able to query by date but when I do, I get no results, as soon as I take out the date criteria, I get the results but I need the date in there. There are no results from today so any dates will be from yesterday or before.
Ideally I would like to enter a persons initials and a date and have the results show. If I put [Enter Initials] in the criteria for "Insp By", I get results for all entries for that person, but regardless of what I put in the criteria for date the results are empty, I would like to be able to use [Enter Date] in the "LabelDate" criteria and get the results for that person on that date.
What am I missing?
DateIssue.zip
Thanks
Dave