How do I show a currency in a query.

[davidnash]

A friend has developed a database at college. All seems pretty well but the query she uses to populate a form and reports is incorrectly displaying the curence. Her main tables are just number fields. The query calculates correctly but her lecturer has told her the query needs to show a £ sign with the figures retrieved. Any ideas?

 

[Smart]

Design the table and in the required columns data type to currency

or

In the field section of the query right click properties and set format to currency.

or

do the same in the report

 

[Rich]

Her lecturer is wrong, how the query displays the value is irrelevant