[Year 12 IT Apps] MS Access help!

Fri Apr 27 17:37:02 EST 2007

Hello Ben

First, if you don't link the tables Access will give you all combinations of 
[selling-price]*[quantity_ordered] being calculated; eg 3 selling prices, 2 
quantity ordered give 6 results. If you want this fine, if not you need to 
create a relationship between the two tables (link) based on a common field.

You say you have linked them - is it via a query? in which case you need to 
attach the query to the form, then create a textbox and use expression 
builder to create the control source for the text box. But, when you do, 
don't select the fields from the '+tables', select it from your form (which 
should be at the top of the list).

An Access form can only be connected to one table at a time so entering 
something like =[tblprices]![price]*[tblqtyinstock]![qtyinstock] won't work. 
You get a name error. Instead you attach to the query (which looks like a 
single table) and the query's 'fields' become the form's fields. Selecting 
'form' in expression builder will give you something like 
=[price]*[qtyinstock]. This works (or should!)

Regards
Robert T-A
Brighton SC

----- 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 