Happy New Year!
I have a Acces query to Concatenate two number fields and I keep loosing the leading zeros. heres what I have;
Value in Field 1..
Value in Field 2..
..I would like the desired concatenated result to be..
..but I keep getting..
10-1 (I keep loosing the leading zeros)
Here is my code in the query;
CONTMAX: "M" & [MaxYr] & "-" & [MaxNum]
Can anyone please help me figure this out!? Thanks a very bunch!