I have recently updated to access 10 64 bit system. Now I get this error when I run my query. This was running fine in the 32 bit access.
Here is the information in the sql view of my query.
SELECT tblProducts.ProductID, tblProducts.ProductName, Sum(nz([Received])-nz([Sold])) AS [Units in Stock]
FROM tblProducts INNER JOIN tblTransactions ON tblProducts.ProductID = tblTransactions.ProductID
GROUP BY tblProducts.ProductID, tblProducts.ProductName;
Can anyone help me get this to work? Thanks in advance.