How do I force the inclusion of leading zero's?

[RobH]

I want to combine two numeric fields the first is the Consultation Reference (CR) the second is the Quotation Number (QN) - I want to display the two combined as a ten digit block - the first 8 being the CR the last two being the QN so the format should appear as ccccccccqq eg 0001482301 would be the first Quotation for Consultation 14823 the problem is I can't work out how to force the include of leading zero's for each feild set.

[missinglinq]

Format(YourFiel d, "000000") where the zeros represent the total number of digits you want the number to have!

Format(1234, "000000") for instance will yield 001234.

Linq ;0)>