Saving calculations done in a form back to a table

  • Thread starter Thread starter PK.10987
  • Start date Start date
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.
 
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.
 
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?)
 
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.
 
Back
Top