Dynamic labels showing multiple records

MathieuCain

Hello,

I have a points feature class containing containing values by date. E.g., Each point may have multiple values (1 per date). The number of date/values may vary between point (and change as more records got added to the table). I would like to display the dates and values for each point in a single label/text box for each point.

E.g.,

point 1
xyz/xyz/xyz     value
xyz/xyz/xyz     value
...

Doing a simple

"location" & vbnewline & [date] & "     " & [value]

would only return one instance, whereas I'd want it to be dynamic in recording all instances sequentially.

Thoughts?