Mar 23, 2006 #1 9martin Technical User Joined Mar 22, 2006 Messages 13 Location US Hello, how can I change a numeric field to only show two decimal places? Thanks, Martin
Mar 23, 2006 #2 BobSuruncle Technical User Joined Jun 18, 2002 Messages 423 Location CA Right-click the field and select "Format Field" from the shortcut menu. Choose one of the formats from the Number tab or click Custom to set by hand. Bob Suruncle Upvote 0 Downvote
Right-click the field and select "Format Field" from the shortcut menu. Choose one of the formats from the Number tab or click Custom to set by hand. Bob Suruncle
Mar 23, 2006 Thread starter #3 9martin Technical User Joined Mar 22, 2006 Messages 13 Location US Thanks Bob, This is what I have done in the past, but in this particular report there is not a number tab?? How can I then do a custom setting? Thanks, Martin Upvote 0 Downvote
Thanks Bob, This is what I have done in the past, but in this particular report there is not a number tab?? How can I then do a custom setting? Thanks, Martin
Mar 23, 2006 #4 synapsevampire Programmer Joined Mar 23, 2002 Messages 20,180 Location US Use a formual to convert it: val({table.field}) Now you can use it instead of the field to format it as Bob suggested. -k Upvote 0 Downvote
Use a formual to convert it: val({table.field}) Now you can use it instead of the field to format it as Bob suggested. -k