[AccessD] How to set a value from one recordset as a parameter fora select statement that is source to another recordset

I created a function and used the function in the select statement.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of JMoss
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
fora 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