Access Queries

  • Thread starter Thread starter Prishani
  • Start date Start date
P

Prishani

Hey there!

I need some help in my MS Query. I have 3 fields.I want to
add the values in the first two fields and display that
value in the third field.This value should be seen in the
table as well as the query.

I tried coding, and I'm not sure if it worked. A message
comes up saying it has updated fields but when I checked
the table, there were no values in this field.
What do I do?
Please Help!
 
Prishani said:
Hey there!

I need some help in my MS Query. I have 3 fields.I want to
add the values in the first two fields and display that
value in the third field.This value should be seen in the
table as well as the query.
Click to expand...

Expressions in queries will never be seen in the tables nor should they be. Just use
the query in all circumstances where you need the calculated value.
 
Back
Top