H hardrock Registered User. Local time Today, 21:20 Joined Apr 5, 2007 Messages 166 Dec 10, 2008 #1 Hello, As an example, my query is returning a price in the format of 47.1 47 but i want to format it in the format of 47.10 47.00 how do i do this please?
Hello, As an example, my query is returning a price in the format of 47.1 47 but i want to format it in the format of 47.10 47.00 how do i do this please?
KenHigg Registered User Local time Today, 16:20 Joined Jun 9, 2004 Messages 13,291 Dec 10, 2008 #2 If this is in a report you can do something like Format: General Number and set Decimal Places: 2 in the text box properties.
If this is in a report you can do something like Format: General Number and set Decimal Places: 2 in the text box properties.
H hardrock Registered User. Local time Today, 21:20 Joined Apr 5, 2007 Messages 166 Dec 10, 2008 #3 Tried that! doesn't seem to work. i know its simply,just can't figure it out!
neileg AWF VIP Local time Today, 21:20 Joined Dec 4, 2002 Messages 5,970 Dec 10, 2008 #4 Format in the query isn't normally importants since users shouldn't see queries. If you really want to, select the coulmn in the query grid, right click, select properties\format\fixed
Format in the query isn't normally importants since users shouldn't see queries. If you really want to, select the coulmn in the query grid, right click, select properties\format\fixed
KenHigg Registered User Local time Today, 16:20 Joined Jun 9, 2004 Messages 13,291 Dec 10, 2008 #5 Is it a numeric data type?
H hardrock Registered User. Local time Today, 21:20 Joined Apr 5, 2007 Messages 166 Dec 10, 2008 #6 I sorted it. I used a format of 00.00;0 in the report text property. Thanks guys
