Table/Form Division Question **BUMP**

B

BardsSweetie

2ND QUESTION:

Hi Allen,

I tried and I still don't get it. Could you possibly explain from start to
finish beginning with the table?

Does it make any difference that I have other information in my table? I
have description, category, ordered and received dates.

Thanks,

Kathleen

----------------------------------------------------------------------------
RESPONSE:

Kathleen, your table should store only the PriceEach and the Quantity, not
the total.

You can then calculate the total amount in a query, as described here:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

----------------------------------------------------------------------------

1ST QUESTION:

I've got my table and forms all set up. All I want to do is divide price paid
by quantity received.

Ex: $25.00 divided by 60

I tried the formula that the Access Help pages gave and I don't get an
answer in the Price Per Unit box.

If anyone can help with this it would be appreciated.

Thanks,

Kathleen
 
A

Al Camp

Bards,
As a rule, don't store the results of a calculation in a table...

If you capture Price and Qty to your table, then... there is no need to
also capture the calculational result of Price/Qty.
You should just "display" the results of that calculation on your form, or
query, or report.

If you place an "unbound" text control on your form (ex. name
PricePerUnit) with a ControlSource of...
=Price/Qty
it will always "display" the correct result... no matter what Price or Qty
are, or... if you change that Price or Qty at a later date.

In any subsequent Query, Form, or Report, you can always re-derive the
PricePerUnit from the "captured" Price and Qty.
 

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