Calculation in a form not entering table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alexandros - 30 Mar 2007 18:02 GMT

Hi all.
I have created a form (Orders Form) to enter some data regarding orders.
This form saves the typed data into the table (Orders Table) including the
customer's ID and Order ID.
All nice and saved into the Orders Table, except from the Total field.
Furthermore, I can type any kind of data into every field in the Orders
Form, apart from the Total field where i have placed the calculation:
=[Subtotal]*[VAT]/100+[Subtotal]. Doing this, i am able to view the total
cost including the VAT.

Later on, i would like to use the Orders Table for further data withdraw.
But, without the total field, it is useless for me...
Can enyone tell me what i am doing wrong?

Signature

Tnx in advance

Reply to this Message

fredg - 30 Mar 2007 18:21 GMT

> Hi all.
> I have created a form (Orders Form) to enter some data regarding orders.
[quoted text clipped - 9 lines]
> But, without the total field, it is useless for me...
> Can enyone tell me what i am doing wrong?

You're attempting to use Access as though it were a spreadsheet.
As a general rule, do NOT store calculated data in your table.

As long as you have stored the individual data fields, such as
[Quantity], [Price], [VAT], etc., anytime you need the total amount
calculate it, in a query, or on a form, or in a report.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

alexandros - 30 Mar 2007 23:50 GMT

thank you, it worked just fine!!!

> > Hi all.
> > I have created a form (Orders Form) to enter some data regarding orders.
[quoted text clipped - 16 lines]
> [Quantity], [Price], [VAT], etc., anytime you need the total amount
> calculate it, in a query, or on a form, or in a report.

Reply to this Message

Douglas J. Steele - 30 Mar 2007 18:25 GMT

In general, computed fields should not be stored in tables.

As fellow Access MVP John Vinson likes to say "Storing calculated data
generally accomplishes only three things: it wastes disk space, it wastes
time (a disk fetch is much slower than almost any reasonable calculation),
and it risks data validity, since once it's stored in a table either the
Total or one of the fields that goes into the total may be changed, making
the value WRONG."

Create a query with that calculation in it, and use the query wherever you
would otherwise have used the table.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message

alexandros - 30 Mar 2007 23:52 GMT

As fredg and you aswered, you have covered my question and it worked as i
wanted to. Thank you very much

> In general, computed fields should not be stored in tables.
>
[quoted text clipped - 21 lines]
> > But, without the total field, it is useless for me...
> > Can enyone tell me what i am doing wrong?

Reply to this Message