Calculated value does not show up in Query

  • Thread starter Thread starter Sbledsoe
  • Start date Start date
S

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?
 
Queries display what they're told to show. Does your query tell Access to
show that field?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
yes it does

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

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
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
 
yes it does
Click to expand...

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.
 
Back
Top