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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
max value 2
Calculate the median value before a specified list 0
Queiry to return highest value or number in a field 6
How do I find the second highest value. 3
Index/Match Functions to Return Concatenated Response 4
Findiing highest and lowest in rows and columns 3
location of highest consecutive values 0

Top