[echenze]

Hello Guys,

I am a newbie and not that much of a developer. I am having a problem with Access 2003: Here it is;

I have two queries that are dependent on one another. The first query runs successfully while the second query, which pulls it data from the first query will not run instead, it produces an error "Data type mismatch"; How do I correct this problem? I really need as much help as I can.

Here is my query -

SELECT [Splash Number].[Product Code],
Sum([Splash Number].Pxp) AS SumOfPxp,
Sum([Splash Number].Pxl) AS SumOfPxl,
Sum([Splash Number].Pxm) AS SumOfPxm,
Sum([Splash Number].Pxh) AS SumOfPxh
FROM [Splash Number]
GROUP BY [Splash Number].[Product Code];

"Splash Number" is a query that runs without any problem and the above query is supposed to pull data from the Splash Number query. Thanks in advance!!

 

[Dragoen]

Hi echenze,

Can you post the Splash Number query too and list properties for the data fields being summed (byte, long, double etc) or upload a sample of the database with the data scrubbed?