nesting a function with query select

S

stickandrock

I have 10 passthrough quiries.

Passthrough quiries because I have 10 remote sites

I have a append table query that I want to run on each site on my local site.

I have created a function that will change my ODBC Connect Str on all my
passthroughs based on the hard coded remote site.

A - Remote Site conf table ex.
3110
3111
3115
3117
3129
3131
3148
3152
3176
3181

Here are my steps I want to accomplish....

Steps
1.Run my function to change all passthroughs to 3110
2.Run my append table query to update a local table with remote site info.
go back to step1 for the next record on the table (ex 3111) and rerun but
step.
Looping through the entire table until all sites are complete.

Thanks for any and all input.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Passthrough Query Results to Local Table 2
iserror function in a query 2
Using a PassThrough Query to Make a Table 1
Median Function Problem w/ select statement 2
Using an Append Query to add multiple records to a table 0
Problem with append query 6
run query with a form command button? 1
Access Query with relationships Too Slow 3

Top