[Year 12 IT Apps] formulas for Access 2010 queries

[Howard, David]

Hi All,

Mike is correct. Calculated fields should be in queries, forms and reports. NOT in tables.

For example in access

Total Cost: [qty] * [unitPrice]

David

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Mike Brookes
Sent: Tuesday, 17 May 2011 6:19 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] formulas for Access 2010 queries

Hi Mark et al

You can't create a calculated field in an Access table, but you can put a textbox, or other control, on a form/report which displays the results of a calculation based on other fields.

Calculated fields are never stored in the table. Since they are derived from other fields in a table the DB would not then be normalised.

Mike

On 17/05/2011 3:08 PM, Mark KELLY wrote:

On 16 May 2011 19:36, Mike Brookes <mikebr at tpg.com.au<mailto:mikebr at tpg.com.au>> wrote:
G'Day again
'Tis true that you shouldn't use a formula in a table

Unless you use Filemaker, in which case the answer is the opposite  :-)

I didn't even know that you could create a calculated field in an Access table...

--
Mark Kelly
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au<mailto:kel at mckinnonsc.vic.edu.au>
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist

Want a good time? Call 0112358. Ask for Mr Fibonacci.






_______________________________________________

http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe

IT Applications Mailing List kindly supported by

http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and

http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110520/5308104f/attachment.html