select distinct and another column...

[tony c]

Hi,
I'm very green at this. I have an access database of containing info
of users in our core facility. Each user has an bank-account#, a
username and a lab affiliation and a bunch of other info.
Some time ago I was shown the 'select distinct' query to generate a
list of unique labs. Very helpful.

I was trying (unsuccessfully) to find out if I could generate a list
of unique bank-account#s using the 'select distinct' query (more than
one per lab) *with the lab affiliation on column 2*.

Any pointers much appreciated,
Kind regards,
Tony

 

[Douglas J. Steele]

SELECT DISTINCT BankAccountNumber, LabAffiliation FROM Table

will return all the unique combinations of values.

 

[tony c]

Perfect. Many thanks,
Tony
PS. I thought I'd tried that - must have got the parenthesis wrong...