[Year 12 IT Apps] MS Access help!

[Litsa Tzelepis]

hi ben, ry this -

1. reate a new query, adding all fields you require from both tables.
2. create a new field followed by the formula - Eg.
Total$:[selling-price]*[quantity_ordered]
once you run the query, the Total$ will be calculated. format the field back
to 2 decimal places.
3. use the query to create a from screen.

hope it helps,
litsa



----- Original Message ----- 
From: "Ben Tallent" <tallent.benjamin.b at edumail.vic.gov.au>
To: "'Year 12 IT Applications Teachers' Mailing List'"
<itapps at edulists.com.au>
Sent: Friday, April 27, 2007 2:15 PM
Subject: [Year 12 IT Apps] MS Access help!


>
>
> 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.
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
Association Inc
>
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
>



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.