Adding Functions

  • Thread starter Thread starter mollyk
  • Start date Start date
M

mollyk

I am trying to set up a database that needs to auto calculate a line of
information. Is this possible?
 
I am trying to set up a database that needs to auto calculate a line of
information. Is this possible?
Click to expand...

25 Apples + New Jersey
Is that the line of information you wish to calculate?
Who knows? You're not giving us much information to answer your
question.

Why not tell us more detail of WHAT you wish to calculate, and I'm
sure someone will be able to tell you how.
 
I am trying to set up a database that needs to auto calculate a line of
information. Is this possible?
Click to expand...

Yes. It would be done in a Query, or perhaps a form or report, not in a Table.

For a more detailed answer please post a more detailed question.
 
Sorry that I wasn't very clear or detailed. The database that I am working
on is a 'tally' sheet. Shortest example possible: the line would include
A+B+C+D+E+F+G. Can I take that line and add it all up & get H?

Still more info necessary?
 
Sorry that I wasn't very clear or detailed. The database that I am working
on is a 'tally' sheet. Shortest example possible: the line would include
A+B+C+D+E+F+G. Can I take that line and add it all up & get H?
Click to expand...

Your table design IS WRONG, then.

If you have a one (something) to many (tallys) relationship, the proper
structure is two tables in a one to many relationship. "Fields are expensive,
records are cheap" - consider instead having a second table with one tally
*per record* rather than additional fields. Someday you'll need fields H and I
- and you'll have to redesign your table, all your queries, all your reports,
all your forms! Ouch!
Still more info necessary?
Click to expand...

With your current design, create a Query. Add the fields A through G. In a
vacant Field cell type

TheSum: NZ([A]) + NZ() + NZ([C]) + NZ([D]) + NZ([E]) + NZ([F]) + NZ([G])

The NZ function will treat blank (empty) field values as zeros; otherwise the
entire sum will be NULL if any field value is NULL.
 
Back
Top