Query field name changes from "Aug-08" to "Aug-8"

  • Thread starter Thread starter cjborntorun
  • Start date Start date
C

cjborntorun

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!
 
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;
 
you are labeling your columns that way ...

for instance, the column name for this:

Sum([08CS].[Aug-08]) AS [Aug-8]

will be Aug-8 ... you can change that to:

Sum([08CS].[Aug-08]) AS [Aug_08]

used underscore instead of dash so name is different than fieldname --
you MAY be able to make the name the same as your fieldname ... but
generally, you must choose a name for a calculated column that is
DIFFERENT than the fieldname...

If you absolutely must have the name the same, than make another query
on top of that to change names...

SELECT [Aug-8] as [Aug-08], ...
FROM queryname


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 :)
*



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;


strive4peace said:
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 :)
*
Click to expand...
Click to expand...
 
I can see why you think that, but I'm not labeling it that way. As
mentioned, Access is replacing what I type with the "Aug-8" you see in the
SQL. This started happening only recently, to queries that have been running
fine for several years. Thanks for your time, I'll seek out the answer on
another board.



strive4peace said:
you are labeling your columns that way ...

for instance, the column name for this:

Sum([08CS].[Aug-08]) AS [Aug-8]

will be Aug-8 ... you can change that to:

Sum([08CS].[Aug-08]) AS [Aug_08]

used underscore instead of dash so name is different than fieldname --
you MAY be able to make the name the same as your fieldname ... but
generally, you must choose a name for a calculated column that is
DIFFERENT than the fieldname...

If you absolutely must have the name the same, than make another query
on top of that to change names...

SELECT [Aug-8] as [Aug-08], ...
FROM queryname


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 :)
*



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;


strive4peace said:
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!
Click to expand...
Click to expand...
Click to expand...
 
P.S. Strive4peace - For your future reference, I think this is the problem
and described by another MVP in your Office discussion group:
http://allenbrowne.com/bug-03.html

cjborntorun said:
I can see why you think that, but I'm not labeling it that way. As
mentioned, Access is replacing what I type with the "Aug-8" you see in the
SQL. This started happening only recently, to queries that have been running
fine for several years. Thanks for your time, I'll seek out the answer on
another board.



strive4peace said:
you are labeling your columns that way ...

for instance, the column name for this:

Sum([08CS].[Aug-08]) AS [Aug-8]

will be Aug-8 ... you can change that to:

Sum([08CS].[Aug-08]) AS [Aug_08]

used underscore instead of dash so name is different than fieldname --
you MAY be able to make the name the same as your fieldname ... but
generally, you must choose a name for a calculated column that is
DIFFERENT than the fieldname...

If you absolutely must have the name the same, than make another query
on top of that to change names...

SELECT [Aug-8] as [Aug-08], ...
FROM queryname


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 :)
*



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!
Click to expand...
Click to expand...
Click to expand...
 
you're welcome ;) good luck

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 :)
*



I can see why you think that, but I'm not labeling it that way. As
mentioned, Access is replacing what I type with the "Aug-8" you see in the
SQL. This started happening only recently, to queries that have been running
fine for several years. Thanks for your time, I'll seek out the answer on
another board.



strive4peace said:
you are labeling your columns that way ...

for instance, the column name for this:

Sum([08CS].[Aug-08]) AS [Aug-8]

will be Aug-8 ... you can change that to:

Sum([08CS].[Aug-08]) AS [Aug_08]

used underscore instead of dash so name is different than fieldname --
you MAY be able to make the name the same as your fieldname ... but
generally, you must choose a name for a calculated column that is
DIFFERENT than the fieldname...

If you absolutely must have the name the same, than make another query
on top of that to change names...

SELECT [Aug-8] as [Aug-08], ...
FROM queryname


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 :)
*



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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top