<HTML>
Mark and Mike<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 <MSC@LUTHER.VIC.EDU.AU>sent:<BR>
<BR>
</B>
<BLOCKQUOTE style="BORDER-LEFT: #f5f5f5 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"><META content="text/html; charset=us-ascii" http-equiv="Content-Type"><META content="Microsoft Word 14 (filtered medium)" name="Generator">
<STYLE><!--
/* Font Definitions */
@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:11.0pt;
font-family:"Calibri","sans-serif";
color:black;
mso-fareast-language:EN-US;}
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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
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.EmailStyle21
{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;}
--></STYLE>
<BODY lang=EN-AU link="blue" vlink="purple" bgcolor="white">
<DIV class=WordSection1>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: windowtext">Mike<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: windowtext"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="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><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: windowtext"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: windowtext; mso-fareast-language: EN-AU">Mark Scott<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: windowtext; mso-fareast-language: EN-AU">Luther College<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: windowtext; mso-fareast-language: EN-AU">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><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: windowtext"><o:p> </o:p></SPAN></P>
<DIV>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: windowtext; FONT-SIZE: 10pt; mso-fareast-language: EN-AU" lang=EN-US>From:</SPAN></B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; COLOR: windowtext; FONT-SIZE: 10pt; mso-fareast-language: EN-AU" lang=EN-US> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <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 style="MARGIN-LEFT: 36pt" class=MsoNormal><o:p> </o:p></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal>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></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman , serif ;','serif'">Hi all</SPAN><o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman , serif ;','serif'"> </SPAN><o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="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><o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman , serif ;','serif'"> </SPAN><o:p></o:p></P>
<DIV>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman , serif ;','serif'">Mark Scott</SPAN><o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman , serif ;','serif'">Luther College</SPAN><o:p></o:p></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="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><o:p></o:p></P></DIV>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman , serif ;','serif'"> </SPAN><o:p></o:p></P><PRE style="MARGIN-LEFT: 36pt"><o:p> </o:p></PRE><PRE style="MARGIN-LEFT: 36pt"><o:p> </o:p></PRE><PRE style="MARGIN-LEFT: 36pt">_______________________________________________<o:p></o:p></PRE><PRE style="MARGIN-LEFT: 36pt"><A 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: 36pt">IT Applications Mailing List kindly supported by<o:p></o:p></PRE><PRE style="MARGIN-LEFT: 36pt"><A 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: 36pt"><A 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 style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-language: EN-AU"><o:p> </o:p></SPAN></P></DIV></BLOCKQUOTE></HTML>
<BR>