send calculated records in forms to tables

E

eman

I have an invoice which i made many calculation in the form itself and now
the results of the calculated records are not showing in the table
 
F

fredg

I have an invoice which i made many calculation in the form itself and now
the results of the calculated records are not showing in the table

That's correct. Calculated data, with very few exceptions, need not be
stored in any table.
Access is not a bigger version of Excel.
As long as you have the data used for the calculation stored, anytime
you need the result of the calculation re-calculate it, in a query, or
directly in an unbound control on a form (as you seem to be now doing)
or in a report (using the same expressions you are using on the form).
 

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

Top