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.

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

"PURVIANCE" wrote:

> 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.

On Sep 8, 7:25*pm, PURVIANCE <PURVIA...@discussions.microsoft.com>
wrote:
> And I need the all info (county1, or county 2, or county 3) under one column,
> not 3 separate ones.
>
> "PURVIANCE" wrote:
> > 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 toset
> > up separate tables for county 2 and county 3 and then run an expressionwhich
> > 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.

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.