Query help

[blazzzercat via AccessMonster.com]

Greetings,

I need to write a query that looks like:

[Trans Date]<{2006-09-30} .And. PAYTO="6704aa" .Or. PAYTO="1337aa" .Or. PAYTO
etc.......

There are over 400 "PAYTO" codes I need to enter. These codes are contained
in a Excel worksheet in column 2. Is there a script genius on this forum that
can help me with a VBA script to build this query so I won't have to type out
every one of them?

Thanks so much in advance.

 

[Guest]

Can't you copy and paste the PAYTO values into an Access table. Then use this
table in your query.