Format last row in table 
Author Message
 Format last row in table

I have a table with a formula on the last row:  =Sum(above)       How do I
format it with a leading dollar sign?  It is displaying 25,000 and I would
like it to display $25,000


Sun, 13 Oct 2002 03:00:00 GMT  
 Format last row in table
Hi Joe,

One way to do this is to change your field code to:

{ =SUM(ABOVE) \# "$#,##0.00;($#,##0.00)" }

Or, when inserting the field in the first place, if you're using Formula on
the Table menu, drop down the Number Format list and choose a format that
suits you.

--
Bill Coan
Templates, wizards, add-ins, and macros for Word
For more information, visit: www.wordsite.com

Quote:




Quote:
> I have a table with a formula on the last row:  =Sum(above)       How do I
> format it with a leading dollar sign?  It is displaying 25,000 and I would
> like it to display $25,000



Sun, 13 Oct 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Adding a new order overwrite the last row in the table

2. Format of Rows Added to a Table

3. adding a table row, without setting same defaults as previous row

4. row heights of table rows added by vba

5. Err No rows at, duplicate table and row names

6. table row text will not show after row insert

7. How to read Access Table row by row?

8. View mdb tables rows by rows

9. OrdinalPosition failure on last row in recordset Access 2000

10. REPOST: Detecting First and Last Row in RecordsetClone.

11. Detecting First and Last row in RecordsetClone.

12. Last row of the selection

 

 
Powered by phpBB® Forum Software