Automating a query to run 27 times (97)

Topic

New Reply

1. I have a union query that prompts the user for two inputs.
A) A name stored in a lookup table(27 entries)
A year – right now the year is 2001. That will change to 2002 in 2002.

2. As it now stands, I have to run the query 27 times. Each time I input the Same Year but a Different Name.

Question: Can this be automated to :
A) read thru the table and get The Name
get The Year automatically inputted

Thanks

Soc

Reply | Quote

Replies

Soc,
take a look at this thread

Reply | Quote