Concatenate

[BBryan]

Hi,
I was using Dwayne Hookam Concatenate function
I was trying to Concatenate 2 different Tables but I am not sure of the Syntax

TestClosure: Concatenate("SELECT DISTINCT [Nde(ClosureWeld) tbl].[ClosureWeldNo] & " * " & [FWelds tbl].[WeldNo] FROM [FWelds tbl] , [Nde(ClosureWeld) tbl] WHERE [Nde(ClosureWeld) tbl].[FWeldsID] = [FWelds tbl].[FWeldsID])

I also tried
TestClosure: Concatenate("SELECT DISTINCT [Nde(ClosureWeld) tbl].[ClosureWeldNo] FROM [Nde(ClosureWeld) tbl] WHERE [Nde(ClosureWeld) tbl].[FWeldsID] = [FWelds tbl].[FWeldsID]) & Concatenate("SELECT DISTINCT FWelds tbl].[WeldNo] FROM [FWelds tbl] WHERE FWeldsID =" & [FWelds tbl].FWeldsID)

It would look like this
CL-01 * W1
CL-02 * W5, CL-03 * W2
CL-04 * W7
CL-05 * W9, CL-06 * W8, CL-07 * W1, CL-08 * W4


Thanks