Concatenate a string

[BBBryan]

Hi,
Can Someone Please help.
I want to Concatenate in my Query a textBox the CL-No's by WorkOrder and by DrawingNo.
I have a query with WorkOrder, DrawingNo, ClosureWeldNo, and some other stuff....
For this Query I have 2 tables - 1 is WorkOrder tbl (With WorkOrder in) and The other is Welds tbl (With DrawingNo And ClosureWeldNo).

I am using Duane Hookom's Concatenate Module.

I am using this right now in my query
CL-No:Concatenate("SELECT DISTINCT[ClosureWeldNo] FROM [Welds tbl] WHERE WorkOrderID =" & [Welds tbl].[WorkOrderID])

It Concatenates by the WorkOrder But I want It to Concatenate by DrawingNo and WorkOrder. (I may have up to 5 drawings in each WorkOrder).

I am not sure how to ad this extra statement by DrawingNo into this code.


Thanks BBryan

 

[MStef]

Write some records in "WorkOrder" tbl and some records in "Welds" tbl.
Tell what is the RELATIONSHIPS, what are the PRIMARY KEY-s,
and which result you want in the Query.

 

[BBBryan]

Hi,
Sorry, I may have not explaned what I was looking for well enough

What I was looking for was to add onto the Where statement to this
CL-No:Concatenate("SELECT DISTINCT[ClosureWeldNo] FROM [Welds tbl] WHERE WorkOrderID =" & [Welds tbl].[WorkOrderID])

After the WHERE WorkOrderID =" & [Welds tbl].[WorkOrderID])
I tried these and the syntax is not right
CL-No:Concatenate("SELECT DISTINCT[ClosureWeldNo] FROM [Welds tbl]DrawingNo =" & [Welds tbl].[DrawingNo])

CL-No:Concatenate("SELECT DISTINCT[ClosureWeldNo] FROM [Welds tbl]WorkOrderID & DrawingNo =" & [Welds tbl].[WorkOrderID] &[Welds tbl].[WorkOrderID])

There is some way to write this and I am not sure how to
Thanks Bryan