Hello All, New to the Access Forum, I'm sure my question has been addressed but i cant seem to find the answer Sorry.... Query not showing records... I have a basic query of 1 table with a between date criteria. I imported the original data from an Excel sheet then I added new fields within Access. I also changed a few data types of a few of the fields. When I run the query using dates within original data dates all is correct, no issues at all. When I run the query using dates of newly added records not a single record shows in the query. Example: All data imported was in the month of March, new records have been added Aug 3,5,8. When searching all of Aug no records shown, when searching the specific day ie. Aug 5 no records shown. In the table they are there, I have refreshed, closed & reopened access but i cant figure out why the records are not being shown. Thanks for any help anyone can give.