[Year 12 IT Apps] MS Access help!

[Litsa Tzelepis]

it still works if you don't, but it would be better if you do.
good call allan.

----- Original Message ----- 
From: "Allan Barnes" <abarnes at aiet.com.au>
To: "'Year 12 IT Applications Teachers' Mailing List'"
<itapps at edulists.com.au>
Sent: Friday, April 27, 2007 3:18 PM
Subject: RE: [Year 12 IT Apps] MS Access help!


> I think you also need to link the two table together to get the
calculations
> to work as well.
>
>
>
>
> Kind regards
>
> Allan Barnes, CEO
> Australian Institute of Education and Training
> P.O. Box 171
> Brunswick West 3055
> Ph: (03) 9387 2051
> FAX: (03) 9387 3470
> Mobile: 0409 428 221
>
> -----Original Message-----
> From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au]
> On Behalf Of Litsa Tzelepis
> Sent: Friday, 27 April 2007 3:14 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] MS Access help!
>
> 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.
>
> _______________________________________________
> 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
> -- 
> Message protected by MailGuard: e-mail anti-virus, anti-spam and content
> filtering.
> http://www.mailguard.com.au/mg
>
> Click here to report this message as spam:
> https://login.mailguard.com.au/report/1suprIsdEc/5II5qOWqbXF9HE4vhNvAZe/0
>
> -- 
> Message protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.
> http://www.mailguard.com.au/mg
>
>
> _______________________________________________
> 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.