multiple fields as source for form combo box

  • Thread starter Thread starter spence
  • Start date Start date
S

spence

This is probably a no-brainer but I'm a complete Access
novice who's inherited a database and is trying to augment
it with a billing module. Here's the deal:

I have a Table with separate fields for Individuals
and Agencies. In any given record there is either a value
in the Individual field OR the Agency field; the two are
always mutually exclusive. What I'm need to do is to be
able to create a combo box in a form that lists all
Individuals AND all Agencies in a single drop down list.
Seems like it would be simple enough but I'm baffled.

Thanks in advance,

spence
 
Hi,
You can use a UNION query for this:

SELECT Individuals From yourTable
WHERE Individuals Is Not Null
UNION
SELECT Agencies From yourTable
WHERE Agencies Is Not Null
 
Back
Top