Concatenate and Append

K

Kentucky

This is the situation

I have 1st table that has multiple entries for one ID

I need to concatenate the memo fields for the IDs

Before I append to the Final Table

Example of 1st table

ID Name Note
3 Smith 1st Entry
3 Smith 2nd Entry
3 Smith 3rd Entry
4 Mars 1st Entry
4 Mars 2nd Entry

Any help would be appreciated!
 
K

Kentucky

Is there a way to do this without a module, I am trying to
just use the query function?
 
A

Allen Browne

No.

After creating your function, you can call the function in a query, just
like using a built-in function.
 
K

Kentucky

How do I do that, I have never done that?

-----Original Message-----
No.

After creating your function, you can call the function in a query, just
like using a built-in function.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Click to expand...
 
A

Allen Browne

To call the function in the query, type something like this into the Field
row of query design:

fConcatChild("MyRelatedTable", "MyPrimaryKeyField", "MyFieldToConcatenate",
"Long", [MyPrimaryKeyField])

This assumes you have copied the code linked previously and pasted it into a
module.
 
Top