Find the highest value in a column

P

PK

I need to find the highest value in a column called employeeID. the
last person to work on the database didn't use auto number and i need
a way to keep track of the highest value for when a new employee is
created.

Anyone got any ideas?
 
M

Michel Walsh

Hi,


DMax("EmployeeID", "Employee")



Hoping it may help,
Vanderghast, Access MVP
 
Top