Form-table updates

  • Thread starter Thread starter Sarah Wagner
  • Start date Start date
S

Sarah Wagner

I've got a fairly simple form connected to just one
table. There are 5 boxes in which I enter an amount paid,
and then a sixth box that adds up the previous 5 for a
total. In the form, it works fine. When I go to the
table (or to run a report), it's not there. Old numbers
that I was putting into the table to check the add
function are still there. I don't understand where the
link was lost and why it won't update.
 
Hi Sarah

You're sixth box is a calculated value and should not be stored in a table.
You simply calculate it when needed. Same thing applies to your report.

Maurice
 
How do I do that? I'd like to have it show up on the
form, but is that not the way it's done?

Thanks--Sarah
 
Hi Sarah,

In your original message you said that "in the form it works fine" ...The
calculation that "is fine" in the form needs to duplicated to the report.

Tables are for storing raw data. If you like viewing results in a table
format, but need to perform calculations, you need to create a query with
the calculation as a new field (Total: [Field1]+[Field2]...). If you create
the query properly, you can treat the query like an excel spreadsheet and
enter data in your data fields and see the calculations as you would in and
Excel spreadsheet. However, you do not have any formatting control over any
of the cells. (And this is not the way it should be done).

A more sophisticated, and ultimately, more useful way to view the data and
calculations, is to create a report based on the query. Reports allow you
formatting options (bold, color, etc.) that you can't get in a query.

Cameo
 
Back
Top