If you are just using a Date you need to remember that for example 01/01/2015, as far as Access is concerned is the first of January 2015 at midnight, anything after midnight will not show up in the query, if you want to use a date as query criteria and you want data for that date to appear in the query output then you need to add one to the date (remember Access sees dates as numbers) or to get data for 01/01/2015 to show you would need to use 02/01/2015 (i am using UK date format) to get the data to include entries for 01/01/2015