[Year 12 IT Apps] MS Access help!

[Ben Tallent]

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.