<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
If you provide a little more information about the table structure
Phillip it should no trouble to help you write the queries.<br>
<br>
Brett Groves<br>
<br>
Peter Dall wrote:
<blockquote class="cite" id="mid_02e401cab9d9_a761b280_f6251780_org_au"
cite="mid:02e401cab9d9$a761b280$f6251780$@org.au" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>#mid_02e401cab9d9_a761b280_f6251780_org_au p.MsoNormal,
#mid_02e401cab9d9_a761b280_f6251780_org_au li.MsoNormal,
#mid_02e401cab9d9_a761b280_f6251780_org_au div.MsoNormal { margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: "Calibri","sans-serif"; }
#mid_02e401cab9d9_a761b280_f6251780_org_au a:link,
#mid_02e401cab9d9_a761b280_f6251780_org_au span.MsoHyperlink { color: blue; text-decoration: underline; }
#mid_02e401cab9d9_a761b280_f6251780_org_au a:visited,
#mid_02e401cab9d9_a761b280_f6251780_org_au span.MsoHyperlinkFollowed { color: purple; text-decoration: underline; }
#mid_02e401cab9d9_a761b280_f6251780_org_au p { margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman","serif"; }
#mid_02e401cab9d9_a761b280_f6251780_org_au span.emailstyle17 { font-family: "Calibri","sans-serif"; color: windowtext; }
#mid_02e401cab9d9_a761b280_f6251780_org_au span.EmailStyle19 { font-family: "Arial","sans-serif"; color: navy; }
#mid_02e401cab9d9_a761b280_f6251780_org_au span.EmailStyle20 { font-family: "Calibri","sans-serif"; color: rgb(31, 73, 125); }
#mid_02e401cab9d9_a761b280_f6251780_org_au .MsoChpDefault { font-size: 10pt; }
#mid_02e401cab9d9_a761b280_f6251780_org_au div.Section1 { page: Section1; }
#mid_02e401cab9d9_a761b280_f6251780_org_au ol { margin-bottom: 0cm; }
#mid_02e401cab9d9_a761b280_f6251780_org_au 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="Section1">
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: black;">Can
anyone help me with functions to do the following?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">Create
the following calculated queries in ACCESS:</span><o:p></o:p></p>
<ul type="disc">
<li class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">Total
Cost$ - The total cost of the booking, including the booking fee<o:p></o:p></span></li>
<li class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">Disc$ -
The total discount amount off the Total Cost$<o:p></o:p></span></li>
<li class="MsoNormal" style=""><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";">Actual
Cost$ - the final cost deducting any discount amount<o:p></o:p></span></li>
</ul>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Peter Dall<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div
style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";"
lang="EN-US">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";"
lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:yr11it-bounces@edulists.com.au">yr11it-bounces@edulists.com.au</a>
[<a class="moz-txt-link-freetext" href="mailto:yr11it-bounces@edulists.com.au">mailto:yr11it-bounces@edulists.com.au</a>] <b>On Behalf Of </b>PIKE
Philip<br>
<b>Sent:</b> Tuesday, 2 March 2010 3:55 PM<br>
<b>To:</b> Year 11 Information Technology Teachers' Mailing List<br>
<b>Subject:</b> RE: [Yr11 Information Technology] System Architecture
presentation<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Thanks
Adrian, A very good resource for SD<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Philip
Pike</span><span style="color: navy;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Director
of ICT</span><span style="color: navy;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Bacchus
Marsh Grammar</span><span style="color: navy;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Sth
Maddingley Rd</span><span style="color: navy;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Bacchus
Marsh 3340</span><span style="color: navy;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Ph
53664800 Ext 849</span><span style="color: navy;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Fax
53664850</span><span style="color: navy;"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">email:
<a class="moz-txt-link-abbreviated" href="mailto:pikep@bmg.vic.edu.au">pikep@bmg.vic.edu.au</a></span><o:p></o:p></p>
</div>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"
lang="EN-US">
<hr align="center" size="2" width="100%"></span></div>
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";"
lang="EN-US">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif";"
lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:yr11it-bounces@edulists.com.au">yr11it-bounces@edulists.com.au</a>
[<a class="moz-txt-link-freetext" href="mailto:yr11it-bounces@edulists.com.au">mailto:yr11it-bounces@edulists.com.au</a>] <b>On Behalf Of </b>Kent
Beveridge<br>
<b>Sent:</b> Tuesday, 2 March 2010 4:05 PM<br>
<b>To:</b> Year 11 Information Technology Teachers' Mailing List<br>
<b>Subject:</b> RE: [Yr11 Information Technology] System Architecture
presentation</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"
lang="EN-US"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: black;">Hi
AJ,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: black;">just
had a quick look at the presentation ..<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: black;">very
nice!<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: black;">Kent.<o:p></o:p></span></p>
</div>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;">
<hr align="center" size="2" width="100%"></span></div>
<div id="divRpF14713">
<p class="MsoNormal" style="margin-bottom: 12pt;"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: black;">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: black;">
<a class="moz-txt-link-abbreviated" href="mailto:yr11it-bounces@edulists.com.au">yr11it-bounces@edulists.com.au</a> [<a class="moz-txt-link-abbreviated" href="mailto:yr11it-bounces@edulists.com.au">yr11it-bounces@edulists.com.au</a>] on
behalf of
Adrian Janson [<a class="moz-txt-link-abbreviated" href="mailto:janson.adrian.a@edumail.vic.gov.au">janson.adrian.a@edumail.vic.gov.au</a>]<br>
<b>Sent:</b> Tuesday, 2 March 2010 2:45 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:sofdev@edulists.com.au">sofdev@edulists.com.au</a>; <a class="moz-txt-link-abbreviated" href="mailto:yr11it@edulists.com.au">yr11it@edulists.com.au</a><br>
<b>Subject:</b> [Yr11 Information Technology] System Architecture
presentation</span><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;"><o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="color: black;">Hi everyone,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">I have just uploaded
a
presentation on System Architecture to my site here:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;"><a
moz-do-not-send="true"
href="http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=75&Itemid=4"
target="_blank">http://www.adrianjanson.com.au/index.php?option=com_docman&task=doc_download&gid=75&Itemid=4</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">The presentation
discusses
motherboards, architecture, memory and ports.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">Adrian <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">Adrian Janson<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">VITTA President<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: black;">Director of ICT,
Melbourne High
School<o:p></o:p></span></p>
</div>
<p><b><span style="color: black;">Important - </span></b><span
style="color: black;">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.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom: 12pt;"><span
style="font-size: 12pt; font-family: "Times New Roman","serif"; color: black;">_______________________________________________
<br>
<a moz-do-not-send="true" href="http://www.edulists.com.au"
target="_blank">http://www.edulists.com.au
</a>- FAQ, resources, subscribe, unsubscribe <br>
Year 11 IT Mailing List kindly supported by <br>
<a moz-do-not-send="true"
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20"
target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a moz-do-not-send="true" href="http://www.vitta.org.au"
target="_blank">http://www.vitta.org.au</a> -
VITTA Victorian Information Technology Teachers Association Inc<span
style="background: white none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><o:p></o:p></span></span></p>
<p style="text-align: center;" align="center"><span
style="background: white none repeat scroll 0% 50%; color: black; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">Click
<a moz-do-not-send="true"
href="https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg=="
target="_blank">here</a> to report this email as spam.<o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p> </o:p></span></p>
<p style="text-align: center;" align="center"><span
style="background: white none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">This
message has been scanned for malware by Websense. </span><a
moz-do-not-send="true" href="http://www.websense.com/"><span
style="background: white none repeat scroll 0% 50%; color: black; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;">www.websense.com</span></a><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";">_______________________________________________
<br>
<a moz-do-not-send="true" href="http://www.edulists.com.au">http://www.edulists.com.au
</a>- FAQ,
resources, subscribe, unsubscribe <br>
Year 11 IT Mailing List kindly supported by <br>
<a moz-do-not-send="true"
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<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></span></p>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";">_______________________________________________
<br>
<a moz-do-not-send="true" href="http://www.edulists.com.au">http://www.edulists.com.au
</a>- FAQ, resources,
subscribe, unsubscribe <br>
Year 11 IT Mailing List kindly supported by <br>
<a moz-do-not-send="true"
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<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></span></p>
</div>
_______________________________________________
<br>
<a moz-do-not-send="true" href="http://www.edulists.com.au">
http://www.edulists.com.au </a> - FAQ, resources, subscribe,
unsubscribe <br>
Year 11 IT Mailing List kindly supported by <br>
<a moz-do-not-send="true"
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html%20">
http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html </a>
- Victorian Curriculum and Assessment Authority and
<br>
<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</blockquote>
<p></p><p><b>Important - </b>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.</p>
</body>
</html>