ConcatRelated: How do I add an additional field?

B

brokeaspoke

Joined
Jul 30, 2012
Messages
1
Reaction score
0
How can I add a second field to concatRelated query? I want to add [lastName] to the code below. Whenever I try I get a syntax error on any lastNames that contain a single quote / apostrophe (') (such as O'Neill, O'Dell, O'Brien, etc.) I thought I had fixed this but then the value in the Origination field is repeated ad nauseum (Origination1, Origination1, Origination1, Origination1, Origination1 instead of Origination2, Origination3, Origination1). Even after reading Allen Browne's missive on quotes I still can't get ti to work properly. I have a feeling it has to do with the number of double (") quotes used but I just can't seemto figure it out.

Here is the code I am using for just the [pagerNo].Again, I want to add [lastName] to this statement.
ConcatRelated(("origination"),"qry_req_SC_unmaster_without_Amcom_NO_Dupes2","[pagerNo] = """ & [pagerNo] & """")

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ConcatRelated 0
Top n query using Allen Browne's "ConcatRelated" 3
DynamicData pages and additional fields on an EDM model 10
How do I refer to existing field name that has an illegal characte 2
How can I add an index field to a table? 5
How do I add a field to a query and make a calculation? 3
How do I add quotes as a constant in an expression? 1
adding to a bound combo box 2

Top