DWUTKA at marlow.com
DWUTKA at marlow.com
Thu Apr 15 16:04:29 CDT 2004
Well, Access doesn't necessarily 'store' the information the way that you see it. So you will need some field to 'sort/group' by. For instance, if you want the 'highest' ID, then GroupBy CourseName and set Max for the ID. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson Sent: Thursday, April 15, 2004 3:45 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Sorting and restricting ComboBox on ListBox contents My error. I only need one. Thanks for noticing. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DWUTKA at marlow.com Sent: Thursday, April 15, 2004 3:45 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Sorting and restricting ComboBox on ListBox contents In the section that you 'want', what is the difference between DSC M and DSC M? Why would you want 2, when you have 1 of everything else? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson Sent: Thursday, April 15, 2004 2:53 PM To: AccessD Subject: [AccessD] Sorting and restricting ComboBox on ListBox contents I am having difficulty figuring this one out. A97. I have a list box with over 130 items all rows are distinct but a few columns are duplicates. The ListBox is sorted on two text fields which puts the ID number out of sequence. The ComboBox sorts and "Groups By" duplicate columns. What I want to do is use the ComboBox to jump to the first instance of one of the duplicate columns. e.g. ID CourseName City 135 CCP EC 90 DIS EC 87 DIS MP 18 DOC CD 17 DOC SR 55 DSC M AL 57 DSC M EC 43 DSC M MP 28 DSC M SF 3 DSC M SR What I want is: 135 CCP EC 90 DIS EC 18 DOC CD 55 DSC M AL 3 DSC M SR What I get is: 135 CCP EC 87 DIS MP 17 DOC SR 3 DSC M SR What needs to be done to what the desired results? Thanks, Jim -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com