Calculation

P

Patricia

If I create a calculation in a form, how can I get it to show up in the
table? -OR- How do I put in a calculation in a table that will apply to a
form? Should I just not have it calculated and just use a query?

Thank you in advance for your help.
 
J

Jeff Boyce

Patricia

I think you'll find a strong consensus in these newsgroups that trying to
embed a calculated value in a table is rarely a good idea. Doing the
calculation in a query means every time you need the result, it is using the
most up-to-date data.

Access is a relational database, not a spreadsheet. As far as I know, you
cannot embed a "calculation" in a table.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top