[AccessD] How to set a value from one recordset as a paramete r for a select statement that is source to another recordset

It sounds to be that you need to use the first query as a sub query of the
second. To do this copy the sql of the first query, put brackets around it,
and paste it into the criteria line of the appropriate field of the second
query. As long as the first query is only returning one "answer" ie one
field of one record, it should work. Good luck
Jim Hale

-----Original Message-----
From: JMoss [mailto:jmoss111 at bellsouth.net]
Sent: Wednesday, June 16, 2004 8:05 PM
To: Accessd at Databaseadvisors.Com
Subject: [AccessD] How to set a value from one recordset as a parameter
for a select statement that is source to another recordset


Is there a way to do this? I have select distinct COID statement as source
for a recordset that I'm looping through, and want to use the distinctly
selected COID as a parameter in a select statement that is recordsource for
another recordset that I'm using to create Excel files.

Thanks in advance for any help!

Jim

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com