how do I format colums of # to $ and sum of on an Access spredsht

  • Thread starter Thread starter Guest
  • Start date Start date
Access doesn't have spreadsheets. You can apply formatting in text boxes on
forms and reports.
 
how do I format colums of # to $ and sum of on an Access spredsht
Click to expand...

Excel is a spreadsheet program.

Access is a relational database.

THEY ARE DIFFERENT. You can format data in Access Forms and Reports
(and even in queries); you can create a Totals query to calculate sums
of data in a Table; but if you're trying to use an Access table as a
spreadsheet, you're trying to drive nails with a crescent wrench.
Where you need a hammer, use a hammer; where you need a spreadsheet,
use Excel.

John W. Vinson[MVP]
 
Back
Top