[Year 12 IT Apps] MS Access help!

[Ben Tallent]

Hi all,

 

I was wondering if anyone could help with this problem. I am trying to
create a calculation field in Access drawing data from one table and data
from another to work out a calculation. The current fields are selling_price
in the stock table and quantity_ordered in the ordered table. In the order
form I would like to work out the payment amount by multiplying the
quantity_ordered by the selling_price from the stock table. Any help would
be greatly appreciated.

 

Cheers,

 

Ben Tallent

Information Technology

Red Cliffs Secondary College


Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.