You want to use the function ValueList() in the second query
select * from table
where RecordID in (#ValueList(FirstQuery.RecordID)#)
>
> I am using a database query which gets a value from a URL Parameter and
> returns all of the records associated with that Parameter. So
> far, so good.
> Next, I want to use the RecordID from the first query in a second query.
> The problem is that when I try it, I only get the first recordID to appear
> in the Second Query.
>
> Does this make sense? If so, can anyone help.
>
> Thanks,
>
> David
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
