<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" 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)">
<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="PlaceType" downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place" downloadurl="http://www.5iantlavalamp.com/"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Rage Italic";
panose-1:3 7 5 2 4 5 7 7 3 4;}
@font-face
{font-family:"Lucida Calligraphy";
panose-1:3 1 1 1 1 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@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><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='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><br>
<br>
</span></font><strong><b><font face=Tahoma><span style='font-family:Tahoma;
font-weight:normal'><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'> </span><o:p></o:p></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>
</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>