I'm trying to create a report which has four fields. One of these fields has an address crammed into one field with the values seperated by |.
I created a function to split the string into their individual values and then give me the zip code. However, I can't get it to work in the Report.
The value in the table looks like this
COLE,GRACE|APT 908|6631 WAKEFIELD DRIVE||ALEXANDRIA|VA|22307
I'm trying to get the very last value.
This function works perfectly fine and gives me the returned value of 12345 when I put it in the Control Source property
This function gives me #error when I put it in the Control Source property
So basically I think the text isn't getting through, so I need to know how I get the string value of a field value in a report when it's gathered by a query.