Support 805.461.7300
Sales
Our Technology. Your Success.

Insert Commas into proper places within a number

Before running the command, pull down the Edit menu to Fields and make sure your field is wide enough to hold the command.

Replace all amount with IIF(LEN(ALLT(amount))>6 ,LEFT(ALLT(amount),LEN(ALLT(amount))-6)+","+SUBSTR(ALLT(amount),LEN(ALLT(amount))-5),ALLT(amount))
Replace all amount with IIF(LEN(ALLT(amount))>3,LEFT(ALLT(amount),LEN(ALLT(amount))-3)+","+SUBSTR(ALLT(amount),LEN(ALLT(amount))-2),ALLT(amount))

The command works with a field named Amount, so change the name of that field in the command to the field you're working with in your database.

« Back to Commands

As usual AccuZIP6 Tech and Customer Service support is outstanding!
D.H., Forest Grove, OR