[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