Max of value

  • Thread starter Thread starter ANSWER
  • Start date Start date
A

ANSWER

I have one table with 10 fields,
ID is primary key and I want to find max of ID in my search form.
For example: Bill Biks have next education:
1. Primary school
2. Secondary school
3. High school
4. College

Now I want to take just College. The problem is because for
some persons fill order is a bit changed and looks upside down
or just have one, the max education
 
I'm not 100% sure I understand what you're after here, but to find the last
entry for the table:
SELECT Max(ID) As MaxID, Education FROM tblMyTable

To find the last entry for "College":
SELECT Max(ID) As MaxID, Education FROM tblMyTable
WHERE T1.Education = "College"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top