Finding Oldest and Newest Records

[danz013]

Hi There,

I need to get visual basic to find the record with the most recent date and give me the value of the date. Can someone give me an idea as to what the coding would be.

Would I need to use a DLookup statement?

 

[pbaldy]

You could try DMax and DMin to find the dates.

 

[danz013]

Thanks alot. Thats exactly what I was looking for. Couldn't remember the name!