In a table the "TestID" is PK is AutoNumber and format is set "000" so
to display leading zeros for numbers less than 100. I have the next field
is for "TestDate" and format is ShortDate. In a query I want to want to
concatenate these two fields with "-" separating them e.g 065-08/08/08 to
generate a Job Number.
In the query I have built "JobNum:[TestID]&"-"&[TestDate] and I get
result without leading zeros. e.g. "65-08/08/08"

How do I build this so that the "TestID" is converted to text first and
give "065-08/08/08"



--
With Thanks, Rob