[Year 12 IT Apps] MS Access help!

[Litsa Tzelepis]

is your problem field formatted to a number?

----- 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 3:28 PM
Subject: RE: [Year 12 IT Apps] MS Access help!


> The tables are linked already. I tried using the expression builder in the
> properties box on the form and it will show you all the fields from each
> table. I added all the required fields but it just came up with #name!
>
> -----Original Message-----
> From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au]
> On Behalf Of Allan Barnes
> Sent: Friday, 27 April 2007 3:18 PM
> To: 'Year 12 IT Applications Teachers' Mailing List'
> 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
>
>
> 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.