By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Max of value

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.