[Year 12 IT Apps] MS Access help!

[Robert Hind]

Hi Ben,

Difficult to give you an answer without knowing the complete structure of 
your database.

You can do it either via a query including a calculated field or you can do 
a calculation on the order form.

Do you want to store the calculated result in your database? If not, why 
not? and If so then where? This does have an effect on the way you carry out 
the calculation.

Robert Hind (Semi-retired)
Ex Traralgon and Ashwood

----- Original Message ----- 
From: "Kent Beveridge" <kbeveridge at stbc.vic.edu.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Friday, April 27, 2007 5:09 PM
Subject: RE: [Year 12 IT Apps] MS Access help!


> Would this have anything to do with the Plato sample task for the school 
> uniform exchange database from Nelson?
> If it is, I'd be interested too...
> Kent.
>
> Kent Beveridge,
> I.T. co-ordinator
> St. Brigids Catholic Sec. College
> Horsham
>
> Wishes and Eggs, one you make and one you break!  A bit like promises.....
>
> "This email and any attachments may be confidential.  You must not 
> disclose or use the information in this email if you are not the intended 
> recipient.  If you have received this email in error, please notify us 
> immediately and delete the email and all copies.  The School does not 
> guarantee that this email is virus or error free.  The attached files are 
> provided and my only be used on the basis that the user assumes all 
> responsibility for any loss, damage or consequence resulting directly or 
> indirectly from the use of the attached files, whether caused by the 
> negligence of the sender or not.  The content and opinions in this email 
> are not necessarily those of the School."
>
> ________________________________
>
> From: itapps-bounces at edulists.com.au on behalf of Ben Tallent
> Sent: Fri 4/27/2007 2:15 PM
> To: 'Year 12 IT Applications Teachers' Mailing List'
> 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 <http://www.edulists.com.au/>  - FAQ, 
> resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au <http://www.vcaa.vic.edu.au/>  - Victorian 
> Curriculum and Assessment Authority and
> http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian 
> Information Technology Teachers Association Inc
>
>
>
> _______________________________________________
> 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