Join Memofields

[Gerrit.B]

In my query i have several memo fields.
I want to count and join this to new memofield.

See details below.

Line1[INDENT]Certificate1
Certificate2
Certificate3[/INDENT]
Line2[INDENT]Certificate1
Certificate2[/INDENT]
Line3[INDENT]Certificate1
Certificate3
Certificate4[/INDENT]
Line4[INDENT]Certificate1
Certificate2
Certificate4[/INDENT]


Result should be:[INDENT]4x Certificate1
3x Certificate2
2x Certificate3
2x Certificate4[/INDENT]

Is this possible?

Regards Gerrit

 

[Micron]

Sometimes providing psuedo data in a post just causes the replies to start off on the wrong path. Your sample suggests the information is stored in the database incorrectly (not normalized), and as a result, you are trying to do something that would be so much easier if it wasn't. All you get from such a scenario is more issues like this one.

Not sure what I'm looking at either - query fields that you have called "lines" with rows of data (records) or lines of data that you have posted in columns. Not even sure if that's the output of a query. If this
Certificate1
Certificate2
Certificate3
represents the contents of a memo field, what you'd need complex code or perhaps a Union query on each table field, looking for Certificate1 and create such a Union query for each value to be found (i.e. 1 for Certificate1, 1 for Certificate2, etc.) and then find a way to count those results. A big task which is avoidable if the data is properly normalized.