Combine several fields to one column

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

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


"John" j wrote in message ...
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

This would have to be a UNION query.

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

John wrote:

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