Help with http://www.tek-tips.com/faqs.cfm?fid=4233 1

[eAlchemist]

I've been trying to use this, but I get no results in the concatenation.

Here is my query syntax:
SELECT Query4.Child, Concatenate("SELECT Family FROM Query3 WHERE Child =" & [Child]) AS WhereUsed
FROM Query4
GROUP BY Query4.Child
HAVING (((Query4.Child) Like "010*"));

Here are some records:
Query3
Child Family
010-2639-126 221R-216USA
010-2639-126 221RA216USA
010-2639-126 300R-037
010-2639-126 300R-072JPN11
010-2639-126 300R-072USA
010-2639-126 300R-173
010-2639-126 300R-173AH

Query4
Child
010-2639-126
010-2639-126
010-2639-126

 

[eAlchemist]

Sorry, I forgot to follow-up. I basically get how this thing works. I can't figure out what I'm doing wrong.

Thanks in advance for your help!

 

[PHV]

And this ?
Concatenate("SELECT Family FROM Query3 WHERE Child=[tt]'"[/tt] & [Child] & [tt]"'"[/tt])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[eAlchemist]

PERFECT!!!!!!!!!!!!!!!

You rule PHV. You've helped me out with lots of problems. Thnaks for the tip!

Chris