Stock Currency Formatting

[ozzroo]

Does anyone know a format for a Currency field that I can format like they do for stock price

So instead of £2.47, I want it to read 247p

Any ideas?

Thanks

 

[JerryKlmns]

Select [myPriceField]*100 & "p" FROM myTable;