No values after UNION (service pack 3 problem ??)

[Bart E]

Hi all,

After performing a UNION I have no values but
some weird signs.
This is the statement:

1)
SELECT DISTINCTROW SumAct.[Product Line] as
[PRODUCT_LINE], SumAct.[Product Grp] as [PRODUCT_GROUP],
SumAct.[SD-Code] as [SD_CODE], SumAct.[SD-Name] as
[SD_NAME], SumAct.Area as [AREA], SumAct.PL6_Code_Name as
[PL6_CODE_NAME], SumAct.PL6_Name as [PL6_NAME],
SumAct.SumOfVol as [ACT_AI], SumAct.SumOfNS as
[ACT_NET_SALES], SumAct.SumOfGM as [ACT_GM], SumAct.
[SumOfNS in LC] as [ACT_NET_SALES_LC], SumAct.[SumOfPar on
NS] as [ACT_PARITY_NET_SALES], SumAct.[SumOfPar on Cogs]
as [ACT_PARITY_COGS], NULL as [BUD_AI], NULL as
[BUD_NET_SALES], NULL as [BUD_GM], NULL as
[BUD_NET_SALES_LC]
FROM SumAct, SumBud;
UNION SELECT DISTINCTROW SumBud.[Product Line] as
[PRODUCT_LINE], SumBud.[Product Grp] as [PRODUCT_GROUP],
SumBud.[SD-Code] as [SD_CODE], SumBud.[SD-Name] as
[SD_NAME], SumBud.Area as [AREA], SumBud.PL6_Code_Name as
[PL6_CODE_NAME], SumBud.PL6_Name as [PL6_NAME], NULL,
NULL, NULL, NULL, NULL, NULL, SumBud.SumOfVol as [BUD_AI],
SumBud.SumOfNS as [BUD_NET_SALES], SumBud.SumOfGM as
[BUD_GM], SumBud.[SumOfNS in LC] as [BUD_NET_SALES_LC]
FROM SumAct, SumBud;

I've corrected the problem, this is the statement:

2)
SELECT DISTINCTROW SumAct.[Product Line] as
[PRODUCT_LINE], SumAct.[Product Grp] as [PRODUCT_GROUP],
SumAct.[SD-Code] as [SD_CODE], SumAct.[SD-Name] as
[SD_NAME], SumAct.Area as [AREA], SumAct.PL6_Code_Name as
[PL6_CODE_NAME], SumAct.PL6_Name as [PL6_NAME],
SumAct.SumOfVol as [ACT_AI], SumAct.SumOfNS as
[ACT_NET_SALES], SumAct.SumOfGM as [ACT_GM], SumAct.
[SumOfNS in LC] as [ACT_NET_SALES_LC], SumAct.[SumOfPar on
NS] as [ACT_PARITY_NET_SALES], SumAct.[SumOfPar on Cogs]
as [ACT_PARITY_COGS], '0' as [BUD_AI], '0' as
[BUD_NET_SALES], '0' as [BUD_GM], '0' as
[BUD_NET_SALES_LC]
FROM SumAct
UNION SELECT DISTINCTROW SumBud.[Product Line] as
[PRODUCT_LINE], SumBud.[Product Grp] as [PRODUCT_GROUP],
SumBud.[SD-Code] as [SD_CODE], SumBud.[SD-Name] as
[SD_NAME], SumBud.Area as [AREA], SumBud.PL6_Code_Name as
[PL6_CODE_NAME], SumBud.PL6_Name as [PL6_NAME], NULL,
NULL, NULL, NULL, NULL, NULL, SumBud.SumOfVol as [BUD_AI],
SumBud.SumOfNS as [BUD_NET_SALES], SumBud.SumOfGM as
[BUD_GM], SumBud.[SumOfNS in LC] as [BUD_NET_SALES_LC]
FROM SumBud;

So instead of using NULL I used '0' to correct the problem.
On a computer running W2K,Service Pack 1 or 2 and Access
2000 the first query runs fine.
After SP3 is installed the first query returns some weird
signs. When I use the second query the results are OK.

Does anybody encountered the same problem and has a fixed
solution (so I don't have apply changes to other queries)?
Which changes are deployed in SP3.

Note: When the first query is performed on a WIN XP
computer I have the same problem.

Thanks in advance.

Kind regards,
Bart