Show Last comment entered

D

Doug_C

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!!
 
M

Marshall Barton

Doug_C said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top