pbuethe Returning User Local time Today, 15:10 Joined Apr 9, 2002 Messages 210 Jul 17, 2003 #1 I have currency fields in my reports. I figured out how to round them to the nearest dollar in the query. How do I display them like this but without the .00 on the end? e.g. $123,456.89 becomes $123,457 Thanks.
I have currency fields in my reports. I figured out how to round them to the nearest dollar in the query. How do I display them like this but without the .00 on the end? e.g. $123,456.89 becomes $123,457 Thanks.
Newman Québécois Local time Today, 15:10 Joined Aug 26, 2002 Messages 766 Jul 17, 2003 #2 In your fields properties, right under "format", you have one called (If I remember correctly) "Decimals". It is at "Auto" and should be put at "0".
In your fields properties, right under "format", you have one called (If I remember correctly) "Decimals". It is at "Auto" and should be put at "0".
pbuethe Returning User Local time Today, 15:10 Joined Apr 9, 2002 Messages 210 Jul 17, 2003 #3 Hello Newman! Thanks, that did it. I should have seen that myself.
