ASC Function

[djai695]

Does anyone know a way in which I can convert the strong to show the negative/positive value in the field below. I've tried using the ASC() function, but it does not seem to work. Below is what the field shows me in the query



Field 1
000000000002
000000000000
00000000000K
000000000001
00000000000J

 

[AlexHedley]

Not sure what you mean.

You mention positive/negative which I would think would mean you are talking about a number but you have highlighted a field containing text.

Could you give an example of what it is now and what you want it to actually look like.