Dick If you just want to show dollars only then I would suggest using FORMAT
SELECT (FORMAT(currencyCol, '[>]$999,999')) FROM prevTbl Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Carpet Broker, Dick Fey Sent: Monday, October 24, 2016 11:11 AM To: RBase Maillist <[email protected]> Subject: [RBASE-L] - Brain Dead Have a table with previous Yr & Months sales in currency. Want to reset to Dollars only. Can't for the life of me figure out how to do that in a table. Thanks Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
