There is an autonumber field in the database that is formated 0000 so it always displays 4 digits (ex. 0001, 0100, 1000). In the report it works fine until I concatenate this field with a date field.
Here is my formula...
EC Label: "EC " & Right([Start Date],2) & "-" & [Concept Data.EC Number]
The result is EC 02-1. I expect to see EC 02-0001.
Any ideas on how I can keep the 0000 format for Concept Data.EC Number?
Thanks for you help.
Hillary
Here is my formula...
EC Label: "EC " & Right([Start Date],2) & "-" & [Concept Data.EC Number]
The result is EC 02-1. I expect to see EC 02-0001.
Any ideas on how I can keep the 0000 format for Concept Data.EC Number?
Thanks for you help.
Hillary