Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report field loses format when concatenated 1

Status
Not open for further replies.

Hillary

Programmer
Feb 15, 2002
377
US
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
 
Change the column definition to this:

EC Label: "EC " & Right([Start Date],2) & "-" & Format([Concept Data.EC Number],"0000")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top