Show Last comment entered

[Guest]

Hello,

I have a form with an Update Status field. Each time the user clicks Update
Status, it enters the time and date in a comment field and they can type in
their comments. It is continous and may be as many as 50 entries for one
record in that one field. On my report when I ad that field I do not want all
50 entries to show. Is there a way I can make it where only the last entry
made in that field would show on a report?

Thanks!!

 

[Marshall Barton]

I have a form with an Update Status field. Each time the user clicks Update
Status, it enters the time and date in a comment field and they can type in
their comments. It is continous and may be as many as 50 entries for one
record in that one field. On my report when I ad that field I do not want all
50 entries to show. Is there a way I can make it where only the last entry
made in that field would show on a report?

Oh, the woes of having multiple values in a single field (a
violation of the rules of normalization).

If you can't rectify this design flaw, you will have to use
code to parse out the last "comment". Since you have not
specified the syntax (delimiter string) used to separate the
individual comments, I can't even provide an outline of the
code other than to suggest that the InStrRev function
might(?) be a big help.