John Colby
jwcolby at ColbyConsulting.com
Thu Dec 29 12:23:43 CST 2005
I have a "system" table, with the PKID (autonumber), the name of the system, and the system description: PK Sys Name Sys Descr 1752 AHU7135 Air Handling Units 1754 AHU7137 Air Handling Units 1743 AC0037 Autoclaves (Decon) 1744 AC0038 Autoclaves (Decon) 1745 AC0039 Autoclaves (Decon) Etc. I need to select the PK, Name and description for the FIRST instance of each system of a given description, and populate a combo with the results: 1752 AHU7135 Air Handling Units 1743 AC0037 Autoclaves (Decon) I don't know how to do this is a simple SQL statement. Any suggestions? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/