Zero returned as results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Returning Multiple Results 1
Check box and make table query 1
Sum Expression gives 1.45519152283669E-11 instead of 0 (zero) 6
Exclude Multiple Zeros in Query 4
quandary on selecting certian records 4
Display all results, even zeros, nulls, and blanks 3
Nz function 0
negative values to be returned as zero 6

Back
Top