Create 000 in query output

[mart10]

I am using MS Access 2003

I have a append query where the output needs to be 000

I ave put in Oracle cparty code: "000" in the field header but it keeps appending 0 not 000

 

[HarleyQuinn]

What type of field is it your trying to put "000" into?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PWise]

in the out put try


format(fieldname,"000")

 

[mart10]

trying to put in the 000 into a text field

 

[bubba100]

Try adding a tic so that it is '000. I believe it "sees" 000 as a number which would be 0. The tic declares whatever follows is text.

 

[randy700]

You need the format command.
Putting the single quote will result in '000 in the field.


Randy