Formatting the field in a querry result.

[Mario]

Is there a way to format a field as currency i.e, a
column in querry result to have a Currency symbol in the
front.

In querry's design view I tried right clicking in the
field then properties and format., the drop down box is
empty.

Any help is hightly appreciated.

Thanks
Manik