Concatenate

[Guest]

I was looking at Duane Hookom's example for concatenation where each entry
appears on a separate line but still in the same record. I would like to do
this, but when i tried to execute it, i came up with a concatenation with
commas between entries. My code is as follows:

Concatenate("SELECT qryAI.GA & Chr(9) FROM qryAI WHERE qryAI.Supplier_ID ="
& [qryAI.Supplier_ID] & " AND qryAI.Report_ID =" & [qryAI.Report_ID]) AS
Affiliates

Thank you

 

[Guest]

Never mind i simplified the problem and got it to work.