combining data into one column

[PURVIANCE]

I have data with criteria of county 1, county 2, and county 3. This is under
1 table. I want to query data that has county 1, AND/OR county 2, AND/OR
county 3.

I tried doing it as an expression in county 1, but it won't accept. From
what I am reading, and I am a novice in Access, it looks like I have to set
up separate tables for county 2 and county 3 and then run an expression which
will append the items for me to run a report. Is that correct? Or is there
another way without doing all the tables? Sounds like it could be a problem
if only one table is updated with info.

 

[PURVIANCE]

And I need the all info (county1, or county 2, or county 3) under one column,
not 3 separate ones.

 

[pietlinden]

And I need the all info (county1, or county 2, or county 3) under one column,
not 3 separate ones.

SELECT ....
FROM MyTable
WHERE [Country1] IS NOT NULL
OR
[Country2] IS NOT NULL
OR
[Country3] IS NOT NULL;

No, you *should* normalize, but if you have to, you can create union
queries to create structures that appear normalized. Be warned that
performance is pretty bad, since JET cannot optimize a union query.