Find query - help please

[Johanb26]

Hi guys,

We have an access database, but I am exporting the data to excel via an ODBC connection.

When doing this I want to select queries from more than one section for an excel sheet can somebody please advice.

As an example:

I have 5 different sections and normally each section would go onto a different sheet in excel, but now my engineering manager has gone filter crazy and wants everything on the same sheet.

So this is what I am trying to do:

SELECT cust_id, cust_section
FROM unit
WHERE cust_section = 'section A';

But now I want to include section b, section c, etc... in the same query can somebody please help with the syntax ?

[lfpm062010]

WHERE Cust_Section = 'section A'
OR Cust_Section = 'section B'
OR Cust_Section = 'section C'
OR .... etc

[Johanb26]

WHERE Cust_Section = 'section A'OR Cust_Section = 'section B'OR Cust_Section = 'section C'OR .... etc

But will this not only select section a or section b ? I want to select all the sections.

[recyan]

Why do we have the "WHERE" clause? What happens if we remove it ?
Have you tried lfpm062010's suggestion ?
Explore "<>" and "AND" in "where" clause.

Thanks

[Johanb26]

Why do we have the "WHERE" clause? What happens if we remove it ?
Have you tried lfpm062010's suggestion ?
Explore "<>" and "AND" in "where" clause.

Thanks

Hi the OR syntax did work thanks.

I was just being an idiot. I guess it comes from sleep deprivation ��

[recyan]

Totally understand the part about sleep deprivation playing tricks.
Glad you got things working. In case you have not explored the other options, just try them & see what happens, whenever free.

Thanks