Access 97

  • Thread starter Thread starter Bruce
  • Start date Start date
B

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?
 
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
 
Back
Top