save calculated field

[Guest]

I have a table containing FieldA, FieldB, and Field C. For each record, I
want to add FieldA + FieldB and store the result in FieldC. I then need to
save the table as a txt file and send to someone. Using FieldC: [FieldA] +
[FieldB] in an update query doesn't apparently let me save the contents of
each FieldC. I know I'm overlooking something that should be pretty simple.
Help! How do i do this?

 

[Dan Artuso]

Hi,
Using an Update query *will* update fieldC, thus 'saving' it.

UPDATE yourTable SET FieldC = FieldA + FieldB;

 

[John Vinson]

I have a table containing FieldA, FieldB, and Field C. For each record, I
want to add FieldA + FieldB and store the result in FieldC. I then need to
save the table as a txt file and send to someone. Using FieldC: [FieldA] +
[FieldB] in an update query doesn't apparently let me save the contents of
each FieldC. I know I'm overlooking something that should be pretty simple.
Help! How do i do this?

If you're sending an exported text file, simply base the export on a
Query rather than a table. In a vacant field cell in the query grid
type

C: [A] +

Then use File... Export to export the Query. It is not necessary nor
beneficial to store C redundantly in any table.

John W. Vinson[MVP]