Saving calculations done in a form back to a table

P

PK.10987

Example
I have joined to text fields to create a single field in the form. Now i
want to save it back to a table. What do i do?

Thanks.
 
D

Douglas J. Steele

Why? Store the individual fields in the table, and just concatenate them
whenever you need them. You can do this in a query, and then use the query
wherever you would otherwise have used the table.
 
P

PK.10987

I tried typing in the formula for concatenation but it is not working in the
query. Should the fields to be concatenated be in the same table? Where do I
enter the forumula ( Is it in criteria?)
 
D

Douglas J. Steele

Yes, the fields would have to be in the same table.

You'd enter the calculation for the computed field in an empty cell on the
Fields row of the grid.
 
Top