Text and digits

[Eddie Jackson]

Hi
Every week I download a list to put into a database, however one column has
to be converted manually before entry.
Question:
Can I run a query to convert the following into a database friendly field.
As you can see some are in pence and some are in pounds.
DisplayPrice
30.90p
100.44p
95.24p
978p
473.75p
916p
171.71p
953.90p
£11.83
131p
£10.34
161p
119.81p
188.37p
334.17p
174.80p
124.65p
48.49p
£14.71
795.35p
190.69p
240.89p
647.17p
87.19p
765.5p
501.80p
208.93p

Many regards
Eddie

 

[KARL DEWEY]

Try this --

IIf(Left([DisplayPrice],2)="£",Val(Right([DisplayPrice],Len([DisplayPrice])-2)),Val([DisplayPrice])/100)