Combine several fields to one column

J

John

I gave a table that contains 7 fields Doctor1, Doctor 2, thru Doctor7

I would like a query that will combine all the fields from the table and
display it as one single colume list. This will then be the source for a
list or combo box.

In use the user will choose a doctor, and then the clinic name, and address
will appear in a test box.

Thanks
 
R

Rick B

sounds like you have not followed normalized database design.

Without knowing more, it would be hard to tell you how to revise it, but you
would almost never have a table with multiple fields with the same name, but
a sequence number. This would almost always be a one-to-many relationship.

Tell us more about your database and we can tell you more about the
normalized design.

Rick b
 
J

John Spencer (MVP)

This would have to be a UNION query.

SELECT Doctor1
FROM YourTable
UNION
SELECT Doctor2
FROM YourTable
UNION ...
 
Top