Hi All:

I have fields on the report set to Currency format (properties). The data
for the fields is coming from a query. Some of the fields do show the data
in Currency format and others don't although they all have been set to same
properties.

Any ideas as to why is this happening?

Thanks,
Ajay

You can format the calculated fields at the query level instead using
the CCur function, like:

Extended Cost: CCur([Units]*[UnitCost])

>From: "Ajay Jain" <ajain@i...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Currency Format on report field
>Date: Thu, 19 Sep 2002 14:43:35 -0400
>
>Hi All:
>
>I have fields on the report set to Currency format (properties). The data
>for the fields is coming from a query. Some of the fields do show the data
>in Currency format and others don't although they all have been set to same
>properties.
>
>Any ideas as to why is this happening?
>
>Thanks,
>Ajay
>
>




_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com