Oh never in a table. In a query only. I missed that bit in the original message. I agree fully. <br><br>On Wednesday, March 26, 2014, Natalie H <<a href="mailto:natinga71@yahoo.com">natinga71@yahoo.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div>I'd never store a calculated field in a table. Queries all the way.</div><div><br></div><div>Natalie Heath, Parade College<br>
<br>Sent from my iPad</div><div><br>On 26 Mar 2014, at 8:27 pm, John Schwartz <<a>schwartz@melbpc.org.au</a>> wrote:<br><br></div><blockquote type="cite"><div><div>I am in total agreement.<br><br>Sent from my iPad<div>
<br></div><div>John S. Schwartz</div></div><div><br>On 26 Mar 2014, at 4:44 pm, "Groves, Brett G" <<a>groves.brett.g@edumail.vic.gov.au</a>> wrote:<br><br></div><blockquote type="cite"><div>
<div>
<p><span style="color:#1f497d">Hi all – my 2 centimes<u></u><u></u></span></p>
<p><span style="color:#1f497d"><u></u> <u></u></span></p>
<p><span style="color:#1f497d">Can’t really see the value of calculated fields in Access, maybe it is because I come at it from an SQL perspective but it represents fairly dodgy database practice methinks.<u></u><u></u></span></p>
<p><span style="color:#1f497d"><u></u> <u></u></span></p>
<p><span style="color:#1f497d">Can’t really see how you can have true 3N with a calculated field stored in a table? Or have I got my head around it wrong?<u></u><u></u></span></p>
<p><span style="color:#1f497d"><u></u> <u></u></span></p>
<p><span style="color:#1f497d">I don’t think I’ll be including it at present; students should be using forms (and attendant query) in datasheet view for such operations IMHO<u></u><u></u></span></p>
<p><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p><span>Kind Regards,
<u></u><u></u></span></p>
<p><span><u></u> <u></u></span></p>
<p><span>Brett Groves<u></u><u></u></span></p>
<p><span><image001.gif><u></u><u></u></span></p>
<p><span>Melba College<u></u><u></u></span></p>
<p><span>eLearning Leader<u></u><u></u></span></p>
<p><span>03 9725 8277 Ext 221<u></u><u></u></span></p>
<p><span><a href="http://melba.vic.edu.au/curriculum/elearning/" target="_blank">eLearning Resources for Educators</a> <u></u><u></u></span></p>
<p><span><a href="http://melba.vic.edu.au/curriculum/elearning/elearning-newsletter/" target="_blank">Newsletter sign up</a> <u></u><u></u></span></p>
<p><span><a href="http://us7.campaign-archive1.com/home/?u=3552e93cf6fe9d34510f19694&id=1cc14525a0" target="_blank">Past Issues</a> <u></u><u></u></span></p>
</div>
<p><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a>itapps-bounces@edulists.com.au</a>
[<a>mailto:itapps-bounces@edulists.com.au</a>] <b>On Behalf Of </b>Robert Timmer-Arends<br>
<b>Sent:</b> Thursday, 13 February 2014 5:32 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] MS Access - Calculated fields<u></u><u></u></span></p>
</div>
</div>
<p><u></u> <u></u></p>
<div>
<p><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Hello Damien</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u><u></u></span></p>
</div>
<div>
<p><span style="font-size:12.0pt;font-family:"Times New Roman","serif""> <u></u><u></u></span></p>
</div>
<div>
<p><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">you may find this discussion useful</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u><u></u></span></p>
</div>
<div>
<p><span style="font-size:12.0pt;font-family:"Times New Roman","serif""> <u></u><u></u></span></p>
</div>
<div>
<p><span style="font-size:10.0pt;font-family:"Arial","sans-serif""><a href="http://allenbrowne.com/casu-14.html" target="_blank">http://allenbrowne.com/casu-14.html</a></span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u><u></u></span></p>
</div>
<div>
<p><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">The update at the end covers Access 2010</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""></span></p>
</div></div></div></blockquote></div></blockquote></div></blockquote><br><br>-- <br>Sent from Gmail Mobile<br>
<br>
<p>IMPORTANT! This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Mount St Joseph Girls' College does not represent or warrant that the attached files are free from computer viruses or other defects. The attached files are provided, and may only be used, on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The liability of Mount St Joseph Girls' College is limited in any event to either the resupply of the attached files or the cost of having the attached files resupplied. Any representations or opinions expressed in this email are those of the individual sender, and not necessarily those of Mount St Joseph Girls' College.</p>