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
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