Hi I'm a VBA beginner from Italy.

I need to run a  create query to get let's say a  number of different 

tables, which need to have different names.

The parameter to extract different rows for the various tables is the 

agent code.

I'd like to learn how to loop through one recordset (  where i can read 

the parameter), reading the first field of each row ( =3D agent code ), 

and pass it to the query, saving each time the table with a different 

extension.

Is this possible?

Thanks for your help in advance.

I apologize for my English hoping everything's clear

ciao

Hi,



Yes, I think it is possible, but it does not sound very pretty!



Just where are you having problems. Do you know how to open and loop through

a recordset? Do you know how to pass parameters to a query?



Peter





-----Original Message-----

From: Vladimiro Cerni [mailto:edp@m...]

Sent: July 25, 2001 10:42 PM

To: Access

Subject: [access] query with different parameters





Hi I'm a VBA beginner from Italy.

I need to run a  create query to get let's say a  number of different

tables, which need to have different names.

The parameter to extract different rows for the various tables is the agent

code.

I'd like to learn how to loop through one recordset (  where i can read the

parameter), reading the first field of each row ( = agent code ), and pass

it to the query, saving each time the table with a different extension.

Is this possible?

Thanks for your help in advance.

I apologize for my English hoping everything's clear

ciao