Ned You could print two reports one with the currency format and late another one without the decimal And fix the variable in the Report itself
Mohammed Sattar Utah Group of Companies -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Ned Ritchie Sent: Monday, February 24, 2014 7:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: NO DECIMAL POINT 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 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
