Retrieving most current records

[jdwm2310]

Hi Guys,

I want to retrieve the most current set of records. I have a form (Employee A) this form consist of employee's personal information, the form also includes a command button that will open up a form in read only view. (this form is called Purchases). For example, in Employee A.frm I go to John Stuart then I click on the command button to view his Purchases. He has more than one purchases. I want to view the most recent purchase.

Thanks

 

[CosmoKramer]

Check out Access help for the Max function.....

 

[jdwm2310]

CosmoKramer,

I checked the Max function, but the field that I am interest in is bound, the dmax coding is inserted in the control source.. what should I do?????

 

[bcapps]

I do this in one of my applications, but I am using vbscript on an asp page, you might try this:

 Set maxpurchase = conn.execute("SELECT MAX(Purchase) as max FROM tblpurchases")

Then to retrieve it:

 maxpurchase("max")

Hope this helps.

 

[jdwm2310]

Where do I put this code, in my preview command button

Set maxpurchase = conn.execute("SELECT MAX(Purchase) as max FROM tblpurchases&quot

How about this: maxpurchase("max&quot