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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using DSUM to get running total on a filtered form 0
Update Two Tables Using One Form Contents 0
Save a calculated field in a query back to a field in the table. 1
Data entry to table from a form 1
Saving Control Calculated Fields To Tables 2
Need help on how to pass calculated field from a form to another form 0
Values calculated in a Form entered in the Table? 6
save calculate value 2

Back
Top