[Year 12 IT Apps] formulas for Access 2010 queries

[Brett Groves]

The question is not should you but /why/?? I have never come across a 
good reason for it, probably means your using a raw table view as an 
input device? Bad practice me thinks, very dangerous in large databases, 
always assume the user is a mad bull and you wont go wrong :-) That's 
what forms are for.

Regards
Brett Groves
ICT Manager
Croydon Secondary College

On 17/05/11 15:08, 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

-- 
Regards,
Brett Groves
ICT Manager
Croydon 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 and Early Childhood Development.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110517/c7ae6b2e/attachment.html