Thanks Buddy, I think I need to clarify this a little more. This is for a Point-Of-Sale use.
The data comes from an Invoices TABLE, an InvDetail TABLE, and a Product TABLE where the columns in question are all CURRENCY. The Invoice to the customer is driven from a VIEW of these TABLES and needs to print in CURRENCY format ($123.45). However a moment later the Red 1500 form is put into the printer and the same data needs to print without the decimal (12345) So if we are still on the same page. . . Where does one modify the application to set the value to text and etc? Ned -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Sunday, February 23, 2014 4:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: NO DECIMAL POINT Ned I would set the value to text and then replace the decimal point with nothing. Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ned Ritchie Sent: Sunday, February 23, 2014 7:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - NO DECIMAL POINT I'm still in older DOS and upgrading to Windows. . . Medicare will be requiring NO DECIMAL POINT on dollar amounts on printed paper forms. Example: 123.45 must become 12345 The Report Picture Format in DOS [>]9999.00 gives 123.45 The following Picture Formats just truncate the cents: [>]999999 [>]999900 999999 999900 000000 Any suggestions or workarounds? 2nd question: How would one do it in Windows 7.6? Thank you, Ned Ritchie Judy's Intimate Apparel
