Bill- What I gave you is SQL that you might use in a query. You'll need to fix the names of the fields (State, County) and the name of the table (MyTable). You can start a new query, switch to SQL View, and paste in the text.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: bill0054 [mailto:[EMAIL PROTECTED] > Sent: Friday, March 18, 2005 5:07 PM > To: [email protected] > Subject: [ms_access] Re: Access and VBA > > > > > John, > > > I'm not following you. Can you be more specific. I don't see where > and how you are doing this. > > Bill > > > --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > Bill- > > > > SELECT DISTINCT State, County > > FROM MyTable > > > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > > -----Original Message----- > > > From: bill0054 [mailto:[EMAIL PROTECTED] > > > Sent: Friday, March 18, 2005 1:34 PM > > > To: [email protected] > > > Subject: [ms_access] Access and VBA > > > > > > > > > > > > > > > Hi all, > > > > > > Here is what I'm trying to do. I have a query and part of it has > two > > > fields. The first lists states and the second lists counties. I > want > > > to make a procedure that will select only one county( there are > > > duplicates ) for each state and create a list of states with no > > > repeated counties.I'm not sure where to do this in Access or how. > > > Some have suggested doing it in conjunction with VBA. > > > > > > Thanks for any help, > > > > > > Bill Ellis > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
