Hi,

To be more specific, the format and the order of the Textcol column could be different but 'Duration', 'call result', 'Object' are nots stored in individual column but in a...

Many thanks Jack.

The sql retrieve the two notes. How i can design the query to retrieve more than two the notes (the text is different as the call result's value,...

Ok Jack,

My Notes table looks like this:

Data_Machine_Id ...

Hi Jack,

I ad the 'DateCol' at the output but it doesn'work (name of column non valid 'DateCol').

Also, i cannot retrieve all the phone call notes. The query only extract term...

Re-Hi Jack,

How I can modify the query to obtain the result with the same column but with all the value from a type of phone call note.

The table...

Thanks very much jack.

it works like a charm.

Great help.

regards,

Ozzy