Recent content by chipcain

I'm sorry to have waited so long to respond. I have been pulled off to another "emergency" But I need to thank both vbaInet & dcb for your help. I has indeed helped me with my problem. Thank you, Chip

Here's the List: }-0 J-1 K-2 L-3 M-4 N-5 O-6 P-7 Q-8 R-9 I have an 8 character text field with whole numbers plus numbers that end with one of the characters listed above. As an example: Field1 00000010 0000001} 00000523 0000052R Using a query I was creating a second field (Field2) to...

Hi dcb, I have to be honest this confuses me. I'm not proficient with Access and am not a programmer so I'm not sure how to lay this out. I'm embarassed to ask but can you provide an example of how you would expect it to look. Would you need something more from me?

This does take care of all my positive numbers and the negative numbers represented with the "}". But I still can't seem to put a string together so that this works where }=0, J=1, K=2, ectetera. If I use more than one replace function then I get errors in all the field; including the positive...

I have been asked to convert an alphanumeric field where the alph character represents a number and identifies the whole field as a negative number. I'll try explain by example. Colum one below is the original alpha numeric field and the second colum is what the first clum repesents in numeric...

By now you may have your answer but another possible option would be to create a query that uses a calculated field similar to below: In this case your zipcode field. fFIELDNAME: Format([FIELDNAME],"00000") If you wanted a ten characture field just use 10 zeros. This will also work with...

Just wanted to say thanks to Bob (raskew). This is exactly what I was looking for and it worked like a charm! -chip