Display ColumnHistory of ALL records (not one specified in function) (1 Viewer)

[Mantispony]

Hi all,

you guys (and girls?) have been incredibly helpful so far, so I'm not hesitating to ask yet another question

I know about the ColumnHistory function, but apparently it only displays the ColumnHistory for one particular record (as programmed in the function).

..at least that's what it's doing for me, if and when it works at all.

The function I'm using is:

=ColumnHistory([RecordSource],"Comments","[contact_ID]=" & Nz([contact_ID],0))

modified to mirror my database:

=ColumnHistory([Tabel1],"Commentaar","[ID]=1" & Nz([contact_ID],0))

That doesn't do a lot. I only get an error message saying I made an error in the function spelling..

So I tried removing the ID nr:

=ColumnHistory([Tabel1],"Commentaar","[ID]=" & Nz([contact_ID],0))

..which gave me the exact same result: the same error message.

However, it seems to work for everyone else. What am I doing wrong?

Also, I'd like it to display the history in a form, per record.

Thanks!!

 

[DCrake]

=ColumnHistory([Tabel1],"Commentaar","[ID]=[B][COLOR="Red"]1[/COLOR][/B]" & Nz([contact_ID],0))

Remove

 

[Mantispony]

David,
I tried that again, played around with " marks, but now it's telling me my syntax is wrong, that I may have entered an 'operand' without 'operator' (I'm using a Dutch version, so terms might be different in English)..

I just can't get this to work, and it's rather important that it does..