Currency format for a querry field.

M

Mario

I tried applying the currency format for a querry field,
tru the propery in design mode. But still currency symbol
and two digit decimal are now showing up. Is there an
explict way to apply format in the sQL view like.
Currency(Field1) or Format.Currecncy(Field1)

Please help.
 
M

May

The easiest way for you to do is
in the design view
highlight the filed then right click then properties and
choose the format there

May
MCP in Access and SQL Server
 
M

mario

Actually I did that before and its not showing up. I said
wrongly in my previous post that its showing up., it was
a typo.

Is there any other way. or what is the reason its not
showing up.
 
J

JoeElla

If your field type is declared as currency in the table it will be displayed
with dollar signs and decimal places in the query results.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
FORMATTING RESULTS IN CALCULATED FIELD 4
Formatting the field in a querry result. 0
Currency formatting (Issue with globalization/localization) 1
Record with multiple lines 1
Currency Decimals 5
custom currency symbol independent of regional settings 1
Filtering query results on unincluded field 0

Top