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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i get excell to do if x:y=1 sum it if y:x=2 2
conditional formatting for 2 colums 5
totaling a column then substracting them 1
how to quick calculate sum of colume A1 to A115? 12
Access Query about ticking multiple checkboxes 1
#N/A errors 1
Adding 2 colums of data 8
creating a calculated field 3

Back
Top