We have a contract with one of our customers. As part of the contract we need
to report to them every month on what we have sold them on the contract.

However the contract has 60 different part numbers on it. How can I create a
query to pull out only the 60 part numbers from our thousands of products? I
know how to write queries normally but not with this many or statements.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Keith H" wrote in message
...
We have a contract with one of our customers. As part of the contract we
need
to report to them every month on what we have sold them on the contract.

However the contract has 60 different part numbers on it. How can I create
a
query to pull out only the 60 part numbers from our thousands of products?
I
know how to write queries normally but not with this many or statements.

Hi Don,

Thanks for the offer but unfortunatly the data refers to medical records so
I can't sent it out.

But basicaly I am looking for a way to say to a query If field X equals one
of these valuse then include it. But instead of 9 or 10 possible values there
are between 60 - 100 of them.

Also the data is not stored in Excel to start with, its through an ODBC link
into an Informix system.

"Don Guillett" wrote:

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Keith H" wrote in message
...
We have a contract with one of our customers. As part of the contract we
need
to report to them every month on what we have sold them on the contract.

However the contract has 60 different part numbers on it. How can I create
a
query to pull out only the 60 part numbers from our thousands of products?
I
know how to write queries normally but not with this many or statements.

.