I have a select statement on an unbound control on a form that selects from the name field and then adds some more data from a couple other fields and then orders the selection by name. It works great except when there is a duplicate name in the database. Say that John Doe has two accounts, 12345 and 54321 so his name is in the name field twice. It will allow me to select the first John Doe for account number 12345 but not for 54321. How can I write this select statement to allow it to select either of the names from either account number?

SELECT tblMainFin.txtName1, (tblMainFin.txtName1+" ") & tblMainFin.txtSecondName & tblMainFin.AcctNum FROM tblMainFin ORDER BY [txtName1];

Thanks

Something still isn't right. I changed the column to 1 which is my primary key and it's still pulling in incorrect data in the form. Any ideas?