Calculated value does not show up in Query

[Sbledsoe]

I have a calculated value that is stored in a table. When a query is run on
the table that fields results do not show up. Why and how can I fix it?

 

[Jeff Boyce]

Queries display what they're told to show. Does your query tell Access to
show that field?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[sbledsoe]

yes it does

Queries display what they're told to show. Does your query tell Access to
show that field?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

More info, please...

What is the SQL of the query? What is the field name? How is that field
defined in your table? Which table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

yes it does

Please open the query in SQL view and post the SQL text here. It would also
help to indicate how you're doing the calculation - tables DON'T "store
calculated values" in the sense that Excel cells do.