Hello,
I am trying to concatenage 3 fields together: Location + Year + WONumber using following syntax:
{Location} & "-" &{ Year} & "-" & {WONumber}
Result: LOCATION1-2,009.00-377.00
Could you please help me on how to format to eliminate the separator(,) and decimal? so the result would look like this:
LOCATION1-2009-377
Thanks a million
Tuan