<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
G'Day again<br>
'Tis true that you shouldn't use a formula in a table, however you
can use calculated fields in an input form, query or report eg.
TotalCost:[Quantity]*[Price]<br>
Your query could then select on TotalCost > SomeAmount to select
records eligible for a discount or somesuch.<br>
Functions such as DateDiff, Like (including wild characters),
DatePart, Year, Month and Date are useful in selection criteria
together with the standard boolean operators.<br>
I thought that the "Search Criteria" help was pretty straight
forward but if your little dears resist reading as much as mine did
then copy and paste the help and delete anything you don't think
would be appropriate. If one of the students wants to do a query
which needs some of the other examples you can always point them to
the original help.<br>
<br>
Mike<br>
<br>
<br>
On 16/05/2011 3:02 PM, Mark Scott wrote:
<blockquote
cite="mid:8EB7758DBE426346943A36370038F9B9EB3DA24C3F@lcexch02.luther.local"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Times New Roman \, serif \;";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Calibri","sans-serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;
mso-fareast-language:EN-US;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:4402464;
mso-list-template-ids:-1308849662;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal" style="margin-bottom: 7.2pt; line-height:
160%;"><b><span style="font-size: 12pt; line-height: 160%;
font-family: "Times New
Roman","serif";">From VCAA:<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
7.2pt; margin-left: 31.75pt; line-height: 160%;"><b><span
style="font-family: "Times New
Roman","serif";">Relational database
management system</span></b><span style="font-family:
"Times New Roman","serif";"> <br>
The following functions apply to Unit 3:<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
3pt; margin-left: 81.35pt; text-indent: -17.85pt; line-height:
160%;"><!--[if !supportLists]--><span style="font-family:
Symbol;"><span style="">·<span style="font: 7pt "Times
New Roman";"> </span></span></span><!--[endif]--><span
style="font-family: "Times New
Roman","serif";">create tables<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
3pt; margin-left: 81.35pt; text-indent: -17.85pt; line-height:
160%;"><!--[if !supportLists]--><span style="font-family:
Symbol;"><span style="">·<span style="font: 7pt "Times
New Roman";"> </span></span></span><!--[endif]--><span
style="font-family: "Times New
Roman","serif";">create relationships between
tables<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
3pt; margin-left: 81.35pt; text-indent: -17.85pt; line-height:
160%;"><!--[if !supportLists]--><span style="font-family:
Symbol;"><span style="">·<span style="font: 7pt "Times
New Roman";"> </span></span></span><!--[endif]--><span
style="font-family: "Times New
Roman","serif";">use a range of data types<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
3pt; margin-left: 81.35pt; text-indent: -17.85pt; line-height:
160%;"><!--[if !supportLists]--><span style="font-family:
Symbol;"><span style="">·<span style="font: 7pt "Times
New Roman";"> </span></span></span><!--[endif]--><span
style="font-family: "Times New
Roman","serif";">electronic validation<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
3pt; margin-left: 81.35pt; text-indent: -17.85pt; line-height:
160%;"><!--[if !supportLists]--><span style="font-family:
Symbol;"><span style="">·<span style="font: 7pt "Times
New Roman";"> </span></span></span><!--[endif]--><span
style="font-family: "Times New
Roman","serif";">create, edit and use queries<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
3pt; margin-left: 81.35pt; text-indent: -17.85pt; line-height:
160%;"><!--[if !supportLists]--><span style="font-family:
Symbol;"><span style="">·<span style="font: 7pt "Times
New Roman";"> </span></span></span><!--[endif]--><span
style="font-family: "Times New
Roman","serif";">use of calculated fields<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
3pt; margin-left: 81.35pt; text-indent: -17.85pt; line-height:
160%;"><!--[if !supportLists]--><span style="font-family:
Symbol;"><span style="">·<span style="font: 7pt "Times
New Roman";"> </span></span></span><!--[endif]--><span
style="font-family: "Times New
Roman","serif";">sort records or index on
different fields.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
windowtext;"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
windowtext;">Given that putting formulas into tables is not
standard practice then we are left with the formulas in
queries.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
windowtext;"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
windowtext;">eg </span><span style="font-size: 11pt;
font-family: "Times New Roman","serif";
color: rgb(69, 69, 69);">[Quantity]*[Price]<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
rgb(69, 69, 69);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
windowtext;">Mark Scott<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
windowtext;">Luther College<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; font-family:
"Times New Roman","serif"; color:
windowtext;"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><b><span
style="font-family:
"Tahoma","sans-serif"; color:
windowtext;" lang="EN-US">From:</span></b><span
style="font-family:
"Tahoma","sans-serif"; color:
windowtext;" lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>
[<a class="moz-txt-link-freetext" href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</a>] <b>On Behalf Of </b>Margaret
King Iaquinto<br>
<b>Sent:</b> Monday, 16 May 2011 2:30 PM<br>
<b>To:</b> 'Year 12 IT Applications Teachers' Mailing List'<br>
<b>Subject:</b> Re: [Year 12 IT Apps] formulas for Access
2010 queries<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-right: 0cm; margin-bottom:
12pt; margin-left: 36pt;"><span style="font-size: 12pt;
font-family: "Times New Roman","serif";">Mark
and Mike</span><br>
<br>
What formulas are we expected to teach? I am using Access.<br>
<br>
Maggie<br>
<br>
VK3CFI <br>
<br>
<b>On Mon May 16 12:16 , Mark Scott sent:</b><o:p></o:p></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;">Mike<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;">Thanks,
thatR17;s great but I was hoping someone might have a
simpler version that would be less daunting for my students.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;">Mark
Scott<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;">Luther
College<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;">R20;We
are what we pretend to be, so we must be careful what we
pretend to beR21;<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 11pt; font-family: "Times New
Roman","serif"; color: windowtext;"><o:p> </o:p></span></p>
<div>
<div style="border-right: medium none; border-width: 1pt
medium medium; border-style: solid none none; border-color:
rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color;
padding: 3pt 0cm 0cm;">
<p class="MsoNormal" style="margin-left: 72pt;"><b><span
style="font-family:
"Tahoma","sans-serif"; color:
windowtext;" lang="EN-US">From:</span></b><span
style="font-family:
"Tahoma","sans-serif"; color:
windowtext;" lang="EN-US">
<a class="moz-txt-link-abbreviated" href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>
[<a class="moz-txt-link-freetext" href="mailto:itapps-bounces@edulists.com.au">mailto:itapps-bounces@edulists.com.au</a>] <b>On Behalf Of
</b>Mike Brookes<br>
<b>Sent:</b> Monday, 16 May 2011 1:56 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing
List<br>
<b>Subject:</b> Re: [Year 12 IT Apps] formulas for
Access 2010 queries<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt;"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt;">Hi Mark et Al<br>
<br>
If you click on the help button at the top right of the
screen, type "query criteria" in the search box, then select
"Examples of search criteria" you will get a summary which
includes a few tables showing functions which can be used in
queries plus several examples of their use.<br>
<br>
Mike Brookes<br>
Semi retired gentleman<br>
Copperfield College<br>
<br>
<br>
On 16/05/2011 12:32 PM, Mark Scott wrote: <o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman ,
serif ;","serif";">Hi all</span><span
style="font-size: 11pt;"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman ,
serif ;","serif";"> </span><span
style="font-size: 11pt;"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman ,
serif ;","serif";">I am hoping someone will
have a summary of formulas for Access 2010 queries that they
would be willing to share.</span><span style="font-size:
11pt;"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman ,
serif ;","serif";"> </span><span
style="font-size: 11pt;"><o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman
, serif ;","serif";">Mark Scott</span><span
style="font-size: 11pt;"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman
, serif ;","serif";">Luther College</span><span
style="font-size: 11pt;"><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman
, serif ;","serif";">R20;We are what we
pretend to be, so we must be careful what we pretend to
beR21;</span><span style="font-size: 11pt;"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 11pt; font-family: "Times New Roman ,
serif ;","serif";"> </span><span
style="font-size: 11pt;"><o:p></o:p></span></p>
<pre style="margin-left: 72pt;"><o:p> </o:p></pre>
<pre style="margin-left: 72pt;"><o:p> </o:p></pre>
<pre style="margin-left: 72pt;">_______________________________________________<o:p></o:p></pre>
<pre style="margin-left: 72pt;"><a moz-do-not-send="true" href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<o:p></o:p></pre>
<pre style="margin-left: 72pt;">IT Applications Mailing List kindly supported by<o:p></o:p></pre>
<pre style="margin-left: 72pt;"><a moz-do-not-send="true" href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<o:p></o:p></pre>
<pre style="margin-left: 72pt;"><a moz-do-not-send="true" href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc<o:p></o:p></pre>
<p class="MsoNormal" style="margin-left: 72pt;"><span
style="font-size: 12pt; font-family: "Times New
Roman","serif";"><o:p> </o:p></span></p>
<p class="MsoNormal" style="margin-left: 36pt;"><span
style="font-size: 12pt; font-family: "Times New
Roman","serif"; color: windowtext;"><o:p> </o:p></span></p>
</div>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
<a class="moz-txt-link-freetext" href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
<a class="moz-txt-link-freetext" href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and
<a class="moz-txt-link-freetext" href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc</pre>
</blockquote>
<br>
</body>
</html>