How do I format a cell to get a total of other cells? (numbers)

  • Thread starter Thread starter pfd256
  • Start date Start date
P

pfd256

I am using access 2003. Can a cell be formatted to total numbers from a group
of cells. IE: In excel, a cell can be formatted by entering a formula
=sum(A1:A10) and this will total the numbers in the cells named in the
formula.
 
ACCESS does not work like Excel. You can do totals in queries. Typically,
what I do is take the field (column in Excel) and put it in a separate query
and then do a sum. You can then bring that sum into another query to use. If
you are talking about adding records (rows in Excel) then you have to do some
sort of calculation because ACCESS is not really designed to do that easily.
 
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

Excel Conditional Formatting 1
Excel How to add numbers in same cell? 2
Excel Sumproduct 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Need Countifs Formula Help 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel Macro to automatically go to the right of the last colored cell 0
Excel How to find the most common pairs and triplets numbers? 5

Back
Top