Query help

  • Thread starter Thread starter blazzzercat via AccessMonster.com
  • Start date Start date
B

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.
 
Can't you copy and paste the PAYTO values into an Access table. Then use this
table in your query.
 
Back
Top