Zero returned as results

[jboon]

When I view the datasheet view of my make table query, the data is calculated
as expected. However, when I run the make table query and open the table
created, I receive zero values for the expressions (the summed values are ok).

Please advise!

 

[Allen Browne]

The most likely reason for this discrepency is that Access is understanding
the data types inconsistently. Typecasting the expressions may solve the
problem.

Details in:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html