Splitting control source value string in report

K

Ken Warthen

I have a report based on a crosstab query in an Access 2007 database where
some report control values have data that looks like "1744|1.00|5 for 5".
I'd like to split out the pipe separated values and show them in their own
control. Anybody have experience with something like this?

TIA,

Ken
 
Top