SELECT tblStats.Stats_Date, tblStats.Stats_Stamp_Time, tblStats.Stats_Via
FROM tblStats
WHERE (((tblStats.Stats_Date)=Date()-0) AND ((tblStats.Stats_Via)="L"));
Where Stats is the table where the sales are recorded, Date and time obvious, where tblStats.Stats_Via is the name of the sales...
Scenario I need help with:
Two salesman John and Joe. Both enter sales into a front end access form linked to a back end table.
Two queries one tracking Joe one tracking John's sales by current day, by time of day.
I thought, mistakenly, that if I then build a third query I would get column...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.