Access Queries

[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!

 

[Rick Brandt]

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.

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.

 

[Papi]

Check in ACCESS HELP for the syntax for a UNION query