Access Query -doesn't show calculated value

[Sbledsoe]

I have a calculated value stored in a table, when I run a query on that
table, the values in that field do not show. Why and what can I do about it?

 

[Michel Walsh]

SELECT the field. What is the SQL statement you use (in SQL view, easier to
cut and paste it than to describe the graphical view)? Do you see the field
in data view of the table, directly (to confirm that the field is indeed
stored in the table)?





Vanderghast, Access MVP

 

[Sbledsoe]

In the Select it shows [#11-Mapping Table].[% Surface Area-UP]

And yes I do see the field in the data view on my table.

 

[Michel Walsh]

If the field (header) is visible and nothing is listed as value (in some
rows), then the problem is probably because a field used in the computation
IS NULL. Indeed, in the debug (immediage) window:



? 4 * null [ return ]
Null


and, under a table/query data view, a NULL is displayed as an empty string.

So, not knowing what is your formula, but assuming it is


height * width / CompareToArea


then, if ANY of the three experessions (height, width, compareToArea) IS
NULL, the result is also NULL.



Check if the result where you see nothing matches that pattern.



Vanderghast, Access MVP

In the Select it shows [#11-Mapping Table].[% Surface Area-UP]

And yes I do see the field in the data view on my table.

SELECT the field. What is the SQL statement you use (in SQL view, easier
to
cut and paste it than to describe the graphical view)? Do you see the
field
in data view of the table, directly (to confirm that the field is indeed
stored in the table)?





Vanderghast, Access MVP