Search results

i think that puts me on the right path - stared a new query without totals, only including limited fields - date, transaction number. seems okay, now I'll build up the more complex stuff. for sure a great strategy - go back to basics. BIG THANKS, SJB67.

Ah, yes, #9/1/2015# is correct. here's a screen shot. I need to display the date field so that I can validate the data - not sure how else to get that field displayed but certainly open to suggestion and appreciate the help

im trying to query from a large sales database. every sale or return has a time/date. And I confirmed the data field in Access is "Time/Day" I'm running the criteria as Where the criteria is #9/1/2015" since it's a "where" query - the show box is unchecked. then another field to display...