Update query

[thart21]

I am importing data from Excel formatted like this:

Product 4/1/2008 5/1/2008 6/1/2008 7/1/2008 8/1/2008
8500 3200 500 2500 1050 3000

My table in Access is formatted like this:
product monthdate volume
8500 4/1/2008 3200
8500 5/1/2008 500
8500 6/1/2008 2500
8500 7/1/2008 1050
8500 8/1/2008 3000

Right now I am using an update query and have to run it for each month. Is there a way to do a loop so I don't have to keep changing the monthdate criteria in my query grid?

Thanks,
Toni

 

[pbaldy]

You could open a recordset on the first table and step through the fields, building and executing your query. That would make it a one-click process using whatever fields are present in the source table.

 

[thart21]

Thanks, I'll give it a shot.