Iterative Query

  • Thread starter Thread starter Michael_R_Banks
  • Start date Start date
M

Michael_R_Banks

I have a query that returns 100+, 4-field records. I want to use the
4-fields of data in each record to run another query to return 2 more
fields of data I want to see next to the original 4 fields. If that
made any sense, what's the easiest way to perform this type of
iterative query?
 
I have a query that returns 100+, 4-field records. I want to use the
4-fields of data in each record to run another query to return 2 more
fields of data I want to see next to the original 4 fields. If that
made any sense, what's the easiest way to perform this type of
iterative query?
Click to expand...

Nothing iterative about it, I'd say; just create a third query joining the
first query to the second on those four fields.

If the second query may return multiple hits for each set of four values, you
could base a Form on the first query and a Subform on the second, using

Field1;Field2;Field3;Field4

as the master and child link fields.
 
Back
Top