Connecting Tech Pros Worldwide Help | Site Map

Max of value

ANSWER
Guest
 
Posts: n/a
#1: Nov 13 '05
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


pietlinden@hotmail.com
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Max of value


so you're trying to find the max of the 10 different fields? Sounds an
awful lot like repeating data. put it into a subform, and then you can
use normal summary functions on it in SQL.

Or is the "10 fields in the table" just a red herring?

Closed Thread


Similar Microsoft Access / VBA bytes