<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:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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 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><!--
/* Font Definitions */
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"\@MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I need to created a definition query that queries the lasest sampling event a various locations on my map. For example, I have several historical locations that were sampled for MERCURY, but I only want to show the latest result. The latest dates vary considerable because there’s been a lot of activity at this site. How do I construct my query so that I only pull the latest?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The query below gets verified, but returns no records… I know there are records, so something is wrong. Can anyone help?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='color:#C00000'>"COLL_DATE" = (SELECT MAX( "COLL_DATE" ) FROM Historical_Analytical_Results_Locations_point) AND "MATRIX" = 'WATER' AND "ANALYTE" LIKE 'MERCURY, TOTAL' AND "FLAG_ND" = 0<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks for your help!<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='margin-bottom:10.0pt'><div class=MsoNormal><hr size=2 width="100%" noshade style='color:#008264' align=left></div></div><p class=MsoNormal style='margin-bottom:10.0pt'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>Jim Thomas, GISP</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> | GIS Analyst | </span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>Golder Associates Inc.</span></b><b><span style='font-size:10.0pt;color:teal'> <br></span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>9428 Baymeadows Road, Suite 400, Jacksonville, Florida, USA 32256</span><span style='font-size:10.0pt;color:black'> <br></span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>T: </span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>+1 (904) 363-3430 | </span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>F: </span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>+1 (904) 363-3445 | </span><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>E: </span></b><a name=email></a><a href="mailto:jim_thomas@golder.com"><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>jim_thomas@golder.com</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> | <a name=web></a><a href="http://www.golder.com/"><b><span style='color:black'>www.golder.com</span></b></a></span><b><span style='font-size:10.0pt;color:black'> <br></span></b><br><b><i><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:teal'>Work Safe, Home Safe</span></i></b><b><i><span style='font-size:10.0pt;color:teal'> <br></span></i></b><br><i><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:gray'>This email transmission is confidential and may contain proprietary information for the exclusive use of the intended recipient. Any use, distribution or copying of this transmission, other than by the intended recipient, is strictly prohibited. If you are not the intended recipient, please notify the sender and delete all copies. Electronic media is susceptible to unauthorized modification, deterioration, and incompatibility. Accordingly, the electronic media version of any work product may not be relied upon.</span></i><span style='font-size:7.5pt;color:gray'> <br></span><br><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:gray'>Please consider the environment before printing this email.</span></b><span style='font-size:10.0pt;color:gray'> </span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>