the sign is at the end of the number (access 2000)

[danny_ortega]

I want to import a csv text file that
the records looks like this ...
0001,hammer,12.25+,25
0027,hammer bag,4.85-,1
0035,blue lamp,15.95+,3
0046,lamp bulb,11.85-,1
---this is: ItemId,Description,salesAmt,Quantity

How can I import this file that the field [salesAMT] have the SIGN at the end of the number ?
How can I tell access that a field have the sign at the end.

Thank you

[patt]

I presume that the amount will be imported into the table as a text field.
You could then introduce another field in the table as a currency field and use a query to update that field with the text amount field, like:
NewAmtField=left(textAmtField,len(textAmtField)-1) * iif(right(textAmtField,1)="+",1,-1)
unless someone else has a jazzier idea, if they have, I would also like to see it.
HTH
Pat

[Francois]

Import your third field as a text.
Run an update query to modify the third field to a numeric with following expression:
<pre>IIf(Right([field3],1)="-",Val(Left([field3],Len([field3])-1))*-1,Val(Left([field3],Len([field3])-1)))</pre>