<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=968275115-30092003><FONT face=Arial color=#0000ff size=2>Just
the date in Question</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Andy Lacey
[mailto:andy@minstersystems.co.uk] <BR><B>Sent:</B> Tuesday, September 30,
2003 9:38 AM<BR><B>To:</B> Access Developers discussion and problem
solving<BR><B>Subject:</B> Re: [AccessD] Pull Most
Recent<BR><BR></FONT></DIV>Mike<BR>Do you want to show the field name or the
date in question?<BR><BR>--<BR>Andy
Lacey<BR>http://www.minstersystems.co.uk<BR><BR><BR><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">--------- Original Message --------<BR>From:
"Access Developers discussion and problem solving"
<accessd@databaseadvisors.com><BR>To: "Access Developers discussion
and problem solving" <accessd@databaseadvisors.com><BR>Subject:
[AccessD] Pull Most Recent<BR>Date: 30/09/03 15:35<BR><BR>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN class=161393115-30092003>This is
probably an easy one but I am stumped...</SPAN></FONT></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN
class=161393115-30092003></SPAN></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN class=161393115-30092003>I have 6
fields within my table that have dates in them, how can I pull and display
on a form which field has the most recent date in it?</SPAN></FONT></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN
class=161393115-30092003></SPAN></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN class=161393115-30092003>Thanks in
advance for any help...</SPAN></FONT></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN
class=161393115-30092003></SPAN></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN
class=161393115-30092003></SPAN></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Arial color=#0000ff size=2><SPAN
class=161393115-30092003>Mike</SPAN></FONT></DIV></BLOCKQUOTE><BR><BR>
<HR>
<BR><FONT face="Courier New"
size=2>_______________________________________________<BR>AccessD mailing
list<BR><A class=autolink
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
class=autolink href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A class=autolink href="http://www.databaseadvisors.com/"
target=_blank>http://www.databaseadvisors.com</A><BR></FONT></DIV></BLOCKQUOTE><BR><BR>________________________________________________<BR>Message
sent using UebiMiau 2.7.2<BR></BLOCKQUOTE></BODY></HTML>