Remove leading £ sign from currency field

[gillonia]

I'm trying to write an Access query to remove the leading £ sign from a currency field. Any suggestions on how to do this?

Apologies if this is pretty obvious to some people but it's all new to me.

Thnx for any suggestions,
IanG

 

[mp9]

That depends on the format of the underlying table field.

If it's a numeric field with the Format set to Currency you can just change the format to somethin else in your query designer, e.g. General

If it's a text string field, you can use a function in your query to remove the £ symnbol, e.g.

Mid([YourFieldNameHere],2) extracts everything from the 2nd character on

OR

Replace([YourFieldNameHere],"£","") replaces all occurrences of the £ sign in your field

Hope this helps.

http://www22.brinkster.com/accessory/

 

[m0TiVe]

Is it possible to perform this action with pure SQL (not being the Access engine)? I need to remove a character (the ';') from certain fields (all textfields) since it is the delimiter for an automated exportfile.

Thanks!

 

[BNPMike]

The Access engine is SQL.

 

[DrSimon]

If you've got delimiter characters, they should be removed as the data is imported - how is the data getting there?

 

[SkipVought]

Only mp9 is asking the right question.

There are two basic cases -- NUMERIC & CHARACTER!

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[BNPMike]

If you assign the data to a new numeric field, Access will remove the £ sign for you.