Easy query problem

[PEASLET]

Hi, I was trying to run a query for selected records using their ContactsID number in the criteria field. There are about 300 but they have nothing that links them so I just keyed them in manually. It produced an error 'query too complex'. I'm sure there must be a more effective way of doing this... any ideas?
Thanks (again!)

 

[Liv Manto]

Do they have something else in common, like from the same department, or all terminated employees or name starts with S ?

 

[Pat Hartman]

You can create a new table with a single column. Type the numbers in there, one in each row, and then in a query, join to that table to pull the matching contract numbers from the contract table.

[This message has been edited by Pat Hartman (edited 08-23-2001).]

 

[PEASLET]

aha! I knew there must be a way - there was nothing in common - we just marked them out as growth companies but now I shall flag them as such and I won't have this problem next time!
Thanks