Display the LASTEST TIME from the records returned in Query

[kev100 via AccessMonster.com]

I've got a form which is based on a query.


The requery pulls records from the table based on various previously entered
criteria.


The form simply displays those records in a line-by-line fashion with a
little window-dressing.


One of the fields in each record is TIME displayed in HH:MM:SS AM/PM format.

At the top of the form, I'm needing to display the time of the Most RECENT
entry.

For example.....if there are 3 records.

Record1: 10:06:23 AM
Record2: 12:13:09 PM
Record3: 04:35:05 PM

.....in the report....I'd like to have 04:35:05 PM show somewhere at the top...


Maybe something like:

"Most recent entry: 04:35:05 PM"


Is it possible to do this with just a line of code within the form (and not
by creating a whole other query?)

Thanks very much.

 

[John Spencer]

Try setting the control's source to
=Max(TimeField)

 

[kev100 via AccessMonster.com]

Try setting the control's source to
=Max(TimeField)

I've got a form which is based on a query.

[quoted text clipped - 29 lines]

Thanks very much.

Tried it in the form with an unbound text box and got the ol' #ERROR

Also tried it in the criteria of a query and got similar.