i need help..on sub totals!

[Noor needs your help]

hello everyone
i was wondering if anyone can help me please.. i have a problem
basically i have created a table in microsoft access.. 3 of my feilds are
named:
sub total
vat
and total including vat.
i was wondering if i could create a link between all three feilds.. soo that
when i enter the sub total and tab onto the next column the Vat will already
be calculated for me automatically and thus total including vat
i am thinking there should be a formula or a rule
if anyone does know of how to do this.. could you guide me through as my
knowledge is rather basic.
thank you very much
regards Noor.

 

[Warren]

I am fairly new to access myself however I would expect that calculations for
subtotals and overall pricing would be done in a report and not a table;
based on the question it appears you may be using access as if it were an
excel spreadsheet.
If you need to have subtotal and vat in a table I would create a query to
calculate for total including vat; not sure if this is something that can be
done directly in the table but definitely in a query.
Your query would like:

SELECT table.[sub total], table.vat,

.[sub total]+

.[vat] AS
[total including vat]
FROM table;

substitue your existing table name wherever you see table in the above

 

[Fred]

What Warren said is usually right for situations like yours. If something
can always be calculated, then it should be calculated when it's needed
rather than stored.

Exceptions might include:

- If you have a legal or procedural requirement to make a record of it
- If the "equation" changes (e.g. changes in tax rates, exceptions etc.)

In which case you would probably want code or an update query that loads it
into the field.

I am fairly new to access myself however I would expect that calculations for
subtotals and overall pricing would be done in a report and not a table;
based on the question it appears you may be using access as if it were an
excel spreadsheet.
If you need to have subtotal and vat in a table I would create a query to
calculate for total including vat; not sure if this is something that can be
done directly in the table but definitely in a query.
Your query would like:

SELECT table.[sub total], table.vat,

.[sub total]+

.[vat] AS
[total including vat]
FROM table;

substitue your existing table name wherever you see table in the above

hello everyone
i was wondering if anyone can help me please.. i have a problem
basically i have created a table in microsoft access.. 3 of my feilds are
named:
sub total
vat
and total including vat.
i was wondering if i could create a link between all three feilds.. soo that
when i enter the sub total and tab onto the next column the Vat will already
be calculated for me automatically and thus total including vat
i am thinking there should be a formula or a rule
if anyone does know of how to do this.. could you guide me through as my
knowledge is rather basic.
thank you very much
regards Noor.

 

[Noor needs your help]

Thanks guys you've been a great help
fred:
"If something

can always be calculated, then it should be calculated when it's needed
rather than stored. "

i guess it will be much easier to calculate it at the time its needed.. so
my question is.. can access calculate things for me .. meaning like excel..?
if not can you explain to me how i could update a query that loads it into a
feild?
thank you again you guys are very kind
regards Noor

What Warren said is usually right for situations like yours. If something
can always be calculated, then it should be calculated when it's needed
rather than stored.

Exceptions might include:

- If you have a legal or procedural requirement to make a record of it
- If the "equation" changes (e.g. changes in tax rates, exceptions etc.)

In which case you would probably want code or an update query that loads it
into the field.

I am fairly new to access myself however I would expect that calculations for
subtotals and overall pricing would be done in a report and not a table;
based on the question it appears you may be using access as if it were an
excel spreadsheet.
If you need to have subtotal and vat in a table I would create a query to
calculate for total including vat; not sure if this is something that can be
done directly in the table but definitely in a query.
Your query would like:

SELECT table.[sub total], table.vat,

.[sub total]+

.[vat] AS
[total including vat]
FROM table;

substitue your existing table name wherever you see table in the above

hello everyone
i was wondering if anyone can help me please.. i have a problem
basically i have created a table in microsoft access.. 3 of my feilds are
named:
sub total
vat
and total including vat.
i was wondering if i could create a link between all three feilds.. soo that
when i enter the sub total and tab onto the next column the Vat will already
be calculated for me automatically and thus total including vat
i am thinking there should be a formula or a rule
if anyone does know of how to do this.. could you guide me through as my
knowledge is rather basic.
thank you very much
regards Noor.