query problem

[vilmarie]

I have a table with two field: Char and IDNo(example of data in this fields: L, 00001)

If I make a query and I need that both field appear in one column I write:
id: [Char] & " " & [IDNo]
To obtain: L00001,but when I write this expression in my query the zeros don't appear in the result, only appear L1, wHY?

 

[ByteMyzer]

Try:
[tt]id: [Char] & Format([IDNo],"00000")[/tt]

 

[randy700]

Change this...
[Char] & " " & [IDNo]
to this
[Char] & '" & [IDNo] & "'"

The single quotes will tell access to treat the IDNo field as text. Without them, it's being converting to a number.


Randy