<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (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]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PlaceType"
downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName" downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place" downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Brush Script MT";
panose-1:3 6 8 2 4 4 6 7 3 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
@font-face
{font-family:"Edwardian Script ITC";
panose-1:3 3 3 2 4 7 7 13 8 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Lucida Calligraphy";
panose-1:3 1 1 1 1 1 1 1 1 1;}
@font-face
{font-family:"Rage Italic";
panose-1:3 7 5 2 4 5 7 7 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h1
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:16.0pt;
font-family:Arial;
font-weight:bold;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
p.Custom, li.Custom, div.Custom
{margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
page-break-after:avoid;
font-size:16.0pt;
font-family:"Brush Script MT";
font-weight:bold;
font-style:italic;}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Comic Sans MS";
color:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 color=navy face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:navy'>Hello<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:navy'>Here is some
SQL for eldest in family.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>Eldest in family<o:p></o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>SELECT
ST.SURNAME,ST.FIRST_NAME,ST.STATUS,ST.FAM_ORDER,DF.NO_STUDENTS<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>FROM (ST INNER JOIN DF ON
ST.FAMILY = DF.DFKEY) INNER JOIN UM ON UM.UMKEY = DF.MAILKEY<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>WHERE (STATUS = 'ACTV')
AND (FAM_ORDER =1)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>ORDER BY ST.SURNAME
ASC,ST.FIRST_NAME ASC<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>Eldest in family with homegroup<o:p></o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>SELECT
ST.SURNAME,ST.FIRST_NAME,ST.STATUS,ST.FAM_ORDER,DF.NO_STUDENTS,ST.HOME_GROUP<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>FROM (ST INNER JOIN DF ON
ST.FAMILY = DF.DFKEY) INNER JOIN UM ON UM.UMKEY = DF.MAILKEY<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>WHERE (STATUS = 'ACTV')
AND (FAM_ORDER = 1)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>ORDER BY ST.SURNAME
ASC,ST.FIRST_NAME ASC<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoAutoSig><font size=5 color=navy face="Edwardian Script ITC"><span
style='font-size:18.0pt;font-family:"Edwardian Script ITC";color:navy'>Debbie
Payne</span></font><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=2 color=navy face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy'>Business
Manager</span></font><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoAutoSig><st1:PersonName w:st="on"><st1:place w:st="on"><st1:PlaceName
w:st="on"><font size=2 color=navy face="Comic Sans MS"><span
style='font-size:10.0pt;font-family:"Comic Sans MS";color:navy'>Dorset</span></font></st1:PlaceName><font
size=2 color=navy face="Comic Sans MS"><span style='font-size:10.0pt;
font-family:"Comic Sans MS";color:navy'> <st1:PlaceType w:st="on">Primary
School</st1:PlaceType></span></font></st1:place></st1:PersonName><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 color=navy face="Comic Sans MS"><span
style='font-size:12.0pt;font-family:"Comic Sans MS";color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
busmanagers-bounces@edulists.com.au
[mailto:busmanagers-bounces@edulists.com.au] <b><span style='font-weight:bold'>On
Behalf Of </span></b><st1:PersonName w:st="on"><st1:place w:st="on">Tewkesbury</st1:place>,
Beverley D</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, 17 July 2007 1:38
PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">Business
Managers' Mailing List</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> [Busmanagers] Exporting
Data using Work Sheets</span></font><span lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=3 color=purple face=Arial><span
style='font-size:12.0pt;font-family:Arial;color:purple;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 color=purple face=Arial><span
style='font-size:12.0pt;font-family:Arial;color:purple;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>Good
Afternoon EMR Business Managers,<o:p></o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>I have been
asked to send this on behalf of my colleague in the Office:-</span></font></b><b><font
face=Tahoma><span style='font-family:Tahoma;font-weight:bold'><o:p></o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>On behalf of myself Gill
Lee, and <st1:place w:st="on"><st1:PlaceName w:st="on">Lilydale</st1:PlaceName>
<st1:PlaceType w:st="on">Heights</st1:PlaceType> <st1:PlaceType w:st="on">College</st1:PlaceType></st1:place>
I have a question re exporting data using Work Sheets.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>I wish to export:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>STKEY<o:p></o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>SURNAME<o:p></o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>PREF_NAME<o:p></o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>HOME_GROUP<o:p></o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>for the
YOUNGEST/OLDEST STUDENTS IN A FAMILY ONLY????????????<o:p></o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Can anyone help please? <o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>I have exported using the
DFKEY and deleted the data I did not need however a little time consuming
overall.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Which Table has this data
reference? <o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>What is it called? <o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Can anyone copy and send
me their Work Sheet Stored SQL Statement that works?<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>THANK YOU ALL VERY MUCH<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:36.0pt'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:36.0pt;line-height:8.0pt'><strong><b><font size=1
face=Verdana><span style='font-size:8.0pt;font-family:Verdana;font-weight:normal'>Regards</span></font></b></strong><font
size=1 face=Verdana><span style='font-size:8.0pt;font-family:Verdana'><br>
</span></font><strong><b><font size=6 color="#6600cc" face="Rage Italic"><span
style='font-size:29.0pt;font-family:"Rage Italic";color:#6600CC;font-weight:
normal'>Gill Lee</span></font></b></strong><font size=1 face=Verdana><span
style='font-size:8.0pt;font-family:Verdana'><br>
SSO Admin<br>
<st1:place w:st="on"><st1:PlaceName w:st="on"><strong><b><font face=Verdana><span
style='font-family:Verdana'>Lilydale</span></font></b></strong></st1:PlaceName><strong><b><font
face=Verdana><span style='font-family:Verdana'> <st1:PlaceType w:st="on">Heights</st1:PlaceType>
<st1:PlaceType w:st="on">College</st1:PlaceType></span></font></b></strong></st1:place><strong><b><font
face=Verdana><span style='font-family:Verdana'> M T T</span></font></b></strong><strong><b><font
face=Verdana><span style='font-family:Verdana;font-weight:normal'> </span></font></b></strong></span></font><strong><b><font
face=Tahoma><span style='font-family:Tahoma'><o:p></o:p></span></font></b></strong></p>
<p class=MsoNormal style='margin-left:36.0pt;line-height:8.0pt'><strong><b><font
size=1 face=Verdana><span style='font-size:8.0pt;font-family:Verdana;
font-weight:normal'>e: <a href="mailto:lee.gillian.l@edumail.vic.gov.au"
title="mailto:lee.gillian.l@edumail.vic.gov.au">lee.gillian.l@edumail.vic.gov.au</a></span></font></b></strong><o:p></o:p></p>
<p class=MsoNormal style='margin-left:36.0pt'><strong><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:normal'><o:p> </o:p></span></font></b></strong></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>This is to enable us to send Newsletters to the youngest
member of families only.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>If anyone has any suggestions they would be appreciated.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><strong><b><font size=2 face="Lucida Calligraphy"><span
style='font-size:10.0pt;font-family:"Lucida Calligraphy"'>Bev Tewkesbury</span></font></b></strong><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Business Manager</span></font><o:p></o:p></p>
<p class=MsoNormal><st1:place w:st="on"><st1:PlaceName w:st="on"><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial'>Lilydale</span></font></st1:PlaceName><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> <st1:PlaceType
w:st="on">Heights</st1:PlaceType> <st1:PlaceType w:st="on">College</st1:PlaceType></span></font></st1:place><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>email: </span></font><a
href="mailto:tewkesbury.beverley.d@edumail.vic.gov.au"><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>tewkesbury.beverley.d@edumail.vic.gov.au</span></font></a><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Phone: 9735 7004</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Fax: 9739 5463</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><b><font size=3 face="Times New Roman"><span style='font-size:12.0pt;
font-weight:bold'>Important - </span></font></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.<o:p></o:p></p>
</div>
<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.</p></body>
</html>