ASP Forum Recordset query lancekmc | Posted 6:21am 5. March 2009 Server Time | i have a table from which i have created a query to pick out the info i need and with the max date i.e most recent date against the particular record, and am trying to do this from an SQL statement in VBA looks something like this     strCriteria = "SELECT * FROM qryMaxLabDate_Result WHERE qryMaxLabDate_Result.clinic_code= " _    & "'" & [Forms]![frmMainForm]![txtSelectClinic] & "'" & " AND " _    & " qryMaxLabDate_Result.chart_number='" & [Forms]![frmMainForm]![lstSelectPatient] & "" is that how to refere to fields in the query and how to i get to define the max date to be picked. choonchan | Posted 4:58pm 10. August 2010 Server Time | O4Uvj9  <a href="http://oghfktekxnwh.com/">oghfktekxnwh</a>, [url=http://xmcjbdhliupi.com/]xmcjbdhliupi[/url], [link=http://nurgxzggiskq.com/]nurgxzggiskq[/link], http://srudseeybita.com/ choonchan | Posted 5:48pm 13. August 2010 Server Time | http://www.epiloglaserengraving.com/ health insurance :))) http://www.tarinthai.com/healthinsurancequotes.html colorado health insurance 166214 http://www.whatsatararrel.com/ state auto insurance wurtd http://www.wjcrew.org/ auto insurance agency 459066 http://www.tarinthai.com/lifeinsurancequotes.html garden state life insurance >:O choonchan | Posted 4:37pm 14. August 2010 Server Time | http://www.joshstricklandonline.com/auto.html auto insurance sjntt choonchan | Posted 6:39pm 17. August 2010 Server Time | http://www.bestsleepingpill.net/ buying ambien 28329 http://www.viagra-advice.com/ viagra on line %-[[ http://www.forget-acne.com/ accutane online 8-(( http://www.phentermine-hcl.org/ phentermine dvwi mkaymer | Posted 1:33pm 19. August 2010 Server Time | http://www.cpmythbusters.net/autoinsurance.php auto insurance =-(( mkaymer | Posted 8:41am 21. August 2010 Server Time | http://www.tennismaschile.com/cialis.html cheap prices on cialis %-P http://www.donedems.com/xanax.html xanax =-D http://www.nakuhin.com/ prednisone =))) http://www.donedems.com/accutane.html online pharmacy accutane >:)) mkaymer | Posted 9:02am 22. August 2010 Server Time | http://www.rap-musiq.com/ acomplia 277423 http://www.maldivestouroperators.com/ metoprolol lpjobq http://www.puterilembahpantai.com/ how to get prescription accutane :-[[[ http://www.thenewlicious.com/ cheap ambien perscription 8-[[ http://www.newoxfordmovement.org/ what is prednisone used for 374 mkaymer | Posted 0:11am 29. August 2010 Server Time | http://www.viagra-advice.com viagra rlkr http://www.buyphenterminenow.net/ phentermine xcyb http://www.bestsleepingpill.net/ mixing ambien and xanax and lexapro 12637 http://www.meridiapills.com/ meridia asc Reply to Post Recordset query Back to Forum Page