[Year 12 IT Apps] formulas for Access 2010 queries

Mike Brookes mikebr at tpg.com.au
Tue May 17 18:19:26 EST 2011


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/20110517/a790963b/attachment-0001.html 


More information about the itapps mailing list