Calculated value does not show up in Query

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?
 
J

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
 
S

sbledsoe

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...
 
J

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
 
J

John W. Vinson

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.
 

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

Access Query -doesn't show calculated value 3
Calculated Value does not show up in Query 2
Exclude Multiple Zeros in Query 4
store a calculated value 17
Data changes in append query 1
Adding a query result to a form in Access 2007 1
Storing calculated query results 2
Decimal places in calculated fields 6

Top