use values in table to table for query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

TIA:

Maybe asking too much...

I have Table1 with a Field "CN" containing values. I would like to use each
value of CN in Table1 as criteria for an existing qry Query1, then save the
results as an excel file. I have the output cmd figured out and will use the
CN value as the file name but can't figure out how to go to first record of
Table 1, set a variable to the value of the field CN, use it in a query and
cycle through all CN's in Table1.

I have a command button on a form to trigger the code.

Help is much appreciated,

Joel
 
TIA:

Maybe asking too much...

I have Table1 with a Field "CN" containing values. I would like to use each
value of CN in Table1 as criteria for an existing qry Query1, then save the
results as an excel file. I have the output cmd figured out and will usethe
CN value as the file name but can't figure out how to go to first recordof
Table 1, set a variable to the value of the field CN, use it in a query and
cycle through all CN's in Table1.
Click to expand...

Usually the OpenRecordset method will do it for you.
 
Back
Top