Nlim, the way the report would look as outlined by IFK is:
Primary
All Store Store Other Store
Store Sales Sales Sales
_____ __________ _______ _____________
4006 $47,122.98 $18,681.79 $28,441.19
4010...
IFK, thank you for your assistance.
I appreciate the input. It works fine.
My report needs to go one step further:
1. I needed to get [All Store Sales] that you outlined and
this works fine.
2. I needed to get [All Customer Sales] regardless of
location / store. This is not a...
I have enclosed my SQL to see if anyone can offer a suggestion on how to accomplish my task. If you look at the creation of temporary table ZZMD07, the first on is what is being generated and the second on is what I would like it to be.
What I am attempting to do is find out what stores...
hello,
FYI... if you haven't seen the tech notes for Access 2002, they taughted there are some bug fixes and discrepancy fixes in the 2002 (XP) version with some enhancements.
Good luck
Chuck
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.