SELECT PRODUCT_MASTER.PL3_CATEGORY_ID, PRODUCT_MASTER.PL3_CATEGORY,
PRODUCT_MASTER.[PL4_SUB-CATEGORY_ID], PRODUCT_MASTER.[PL4_SUB-CATEGORY],
PRODUCT_MASTER.PL5_SEGMENT_ID, PRODUCT_MASTER.PL5_SEGMENT,
Sum([06CS].[Jan-06]) AS [Jan-6], Sum([06CS].[Feb-06]) AS [Feb-6],
Sum([06CS].[Mar-06]) AS [Mar-6], Sum([06CS].[Apr-06]) AS [Apr-6],
Sum([06CS].[May-06]) AS [May-6], Sum([06CS].[Jun-06]) AS [Jun-6],
Sum([06CS].[Jul-06]) AS [Jul-6], Sum([06CS].[Aug-06]) AS [Aug-6],
Sum([06CS].[Sep-06]) AS [Sep-6], Sum([06CS].[Oct-06]) AS [Oct-6],
Sum([06CS].[Nov-06]) AS [Nov-6], Sum([06CS].[Dec-06]) AS [Dec-6],
Sum([06CS].Total06CS) AS Total06CS, Sum([07CS].[Jan-07]) AS [Jan-7],
Sum([07CS].[Feb-07]) AS [Feb-7], Sum([07CS].[Mar-07]) AS [Mar-7],
Sum([07CS].[Apr-07]) AS [Apr-7], Sum([07CS].[May-07]) AS [May-7],
Sum([07CS].[Jun-07]) AS [Jun-7], Sum([07CS].[Jul-07]) AS [Jul-7],
Sum([07CS].[Aug-07]) AS [Aug-7], Sum([07CS].[Sep-07]) AS [Sep-7],
Sum([07CS].[Oct-07]) AS [Oct-7], Sum([07CS].[Nov-07]) AS [Nov-7],
Sum([07CS].[Dec-07]) AS [Dec-7], Sum([07CS].TOTAL07CS) AS Total07CS,
Sum([08CS].[Jan-08]) AS [Jan-8], Sum([08CS].[Feb-08]) AS [Feb-8],
Sum([08CS].[Mar-08]) AS [Mar-8], Sum([08CS].[Apr-08]) AS [Apr-8],
Sum([08CS].[May-08]) AS [May-8], Sum([08CS].[Jun-08]) AS [Jun-8],
Sum([08CS].[Jul-08]) AS [Jul-8], Sum([08CS].[Aug-08]) AS [Aug-8],
Sum([08CS].[Sep-08]) AS [Sep-8], Sum([08CS].[Oct-08]) AS [Oct-8],
Sum([08CS].[Nov-08]) AS [Nov-8], Sum([08CS].[Dec-08]) AS [Dec-8],
Sum([08CS].Total08CS) AS Total08CS
FROM ((PRODUCT_MASTER INNER JOIN 06CS ON PRODUCT_MASTER.[10-DIGIT_UPC] =
[06CS].[10-DIGIT UPC]) INNER JOIN 07CS ON PRODUCT_MASTER.[10-DIGIT_UPC] =
[07CS].[10-DIGIT_UPC]) INNER JOIN 08CS ON PRODUCT_MASTER.[10-DIGIT_UPC] =
[08CS].[10-DIGIT_UPC]
GROUP BY PRODUCT_MASTER.PL3_CATEGORY_ID, PRODUCT_MASTER.PL3_CATEGORY,
PRODUCT_MASTER.[PL4_SUB-CATEGORY_ID], PRODUCT_MASTER.[PL4_SUB-CATEGORY],
PRODUCT_MASTER.PL5_SEGMENT_ID, PRODUCT_MASTER.PL5_SEGMENT
HAVING (((PRODUCT_MASTER.PL3_CATEGORY_ID)="USK1" Or
(PRODUCT_MASTER.PL3_CATEGORY_ID)="USK2" Or
(PRODUCT_MASTER.PL3_CATEGORY_ID)="USK3"))
ORDER BY PRODUCT_MASTER.PL3_CATEGORY_ID;
:
please post the SQL for one of your queries
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
have an awesome day
*
cjborntorun wrote:
In my query, the table data for a group of products sums. I set up my
database years ago, and at that time changed the field names so that I would
NOT see fields like this:
SumAug-08
Rather, I use the following field name so that the "Sum" part goes away and
I see only the month-yr combination:
Aug-08: Aug-08
Recently, something has changed and now the zero is being dropped from all
my queries, and I get "Aug-8" instead. This is really screwing up all my
reports, which are dependent on the field name "Aug-08". If I manually
correct the problem, it reverts back to the wrong date when I run the query
again.
Has anyone else seen this and do you know how it happens or how to fix?
Thanks so much!