Access 97

[Bruce]

I am using Access 97. I have a table called maindata with a field called
Turnover, the field contains numbers which need to be shown as thousands of
£.That is 32 should read 32,000, how can I achieve this using an Update
Query?

 

[Brendan Reynolds]

If you want to actually change what is stored in the table ...

UPDATE maindata SET Turnover = (Turnover * 1000)

If you just want to change the way it is displayed, you could use a
calculated column in a select query, e.g. ...

SELECT [Turnover] * 1000 AS Thousands FROM maindata