To set an existing column to currency
Database
2
Posts
2
Posters
0
Views
1
Watching
-
i am using microsoft access to view SQL.I need help on how to set a column to currency [this column result after multiplying the number of units bought(UNIT_BOUGHT) and the unit price(UNIT_PRICE)(unit price is in currency)].So the results are named SUBTOTAL,i want them to contain currency. LudereMP
-
i am using microsoft access to view SQL.I need help on how to set a column to currency [this column result after multiplying the number of units bought(UNIT_BOUGHT) and the unit price(UNIT_PRICE)(unit price is in currency)].So the results are named SUBTOTAL,i want them to contain currency. LudereMP
Are you suing MS Access as a front-end to a SQL back-end database? If so, you can set the column type to 'Currency' in the table designer. Steve