to show only last date from a table

[Mr. G.]

I have a table for employee vacation dates. How can i get a text box in a
form to show only the last vacation date?

 

[John W. Vinson]

I have a table for employee vacation dates. How can i get a text box in a
form to show only the last vacation date?

Set its control source to

=DMax("[vacationdate]", "[tablename]", "[employeeID] = " & [EmployeeID])

using your own field and table names of course.

John W. Vinson [MVP]

 

[Mr. G.]

Thanks
--
Mr. G.

I have a table for employee vacation dates. How can i get a text box in a
form to show only the last vacation date?

Set its control source to

=DMax("[vacationdate]", "[tablename]", "[employeeID] = " & [EmployeeID])

using your own field and table names of course.

John W. Vinson [MVP]