help please with date query

[QuinolKO]

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 the date as Group - with the box checked.

but seems to not work - any guidance on how to fix?

 

[SJB67]

Hi QuinolKO

as a first suggestion your date should be #9/1/2015#
and I would show all the data until you get the query working and keep simple without group/totals until you are happy you are getting the correct data

if still problems do you want to include a screen shot of the query?

 

[QuinolKO]

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

 

[AccessBlaster]

Show a screen shot of TRX_DAT in design view.

 

[SJB67]

Hiya,

I can only see the last 2 columns of your query but can I suggest:

1. take the totals option off (this would remove the group by etc)
2. Put the date in the criteria row of TRX_DAT

you would then be able to see if the query can match the criteria, and if so the lines behind it.

you can then reinstate the totals option once working

it's simplistic but I always go back and build up step by step when I have issues

 

[QuinolKO]

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.