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

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.
 
G

Golfinray

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.
 
Top