Each record has 22 fields, part #, sort date, and then 20 different defects. I want a query to pick the 3 fields with the highest values out of the 20 defect fields. Everything I have found gives you top records, I want top fields.
Novice
Windows 7 64bit 
Access 2007
Each record has 22 fields, part #, sort date, and then 20 different defects. I want a query to pick the 3 fields with the highest values out of the 20 defect fields. Everything I have found gives you top records, I want top fields.
Who is John Galt?
Windows XP Access 2007
That's because in database design, those defects should almost certainly be records in a related table, not fields. The concept is called normalization:Originally Posted by Jbeanski
Everything I have found gives you top records, I want top fields.
http://www.r937.com/Relational.html
I will always be a newbie
Windows 7 64bit Access 2010 32bit
SHow us the data.
Dale
Novice
Windows 7 64bit Access 2007
Query to ignore records where both fields are null
Averages in Access query based on fields in multipleobjects and multiple date fields
Posting Permissions
Reply With Quote