Search results

Tried the first code and it seems to have done the trick. Added the additional filter for previous day and now giving me correct data. I don't know why it stopped but glad it's back working again. Doing my head in. Thanks for the help. Will see how it lasts.

Time field is definitely a date/time field set to short time (24 hour format). I have a seperate field for the date. I keep saying to myself why it worked on one computer but stopped once I ran the database on another.

When I remove one of the 2 time filters it gives me data but it is only filtered by the date. 2 time filters = no data 1 time filter (regardless of which) = all data under date filter. Much like having no time filter in place.

Thanks for the info. Still showing no data after those changes either. If I remove time filter altogether I get all records filtered by dates but it doesn't suit requirements since some fall on a previous shift. I have a at least 2 records that fall within 10.30pm and 11.59pm on previous day...

Thanks for the replies. I have checked and double checked the windows settings. Both are identical. In regards to the naming, I have changed it as suggested and still getting the same result. I know for certain there is data there that should appear within the limits.

Hi all, First time post here and looking for some assistance with a query I have. Running Access 2010 and developed this query to filter out data from a table between times on 2 dates (day before report run and day of report). Covers data from a shift that carries over to the next day...