removing a field(s) from my total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My table is made up of 13 fields where field 1 is labeled period 0, field 2
is labeled period 1.... Often I will sum the data in the columns, but I need
to remove some fields from my total. Is there a method to remove the
unwanted fields from the total without going and alter the expression in the
expression builder?
 
Stefano

If I understand your table design correctly (using fields to contain period
data), the short answer is "no". The qualified answer is "there may be a
way, with lots of work, but it forces Access to behave as if it were a
spreadsheet, not a relational database, so it isn't a good idea."

Have you considered further normalizing your data? If that same data were
in a table that had two fields, like:

YourTable
Period
DataValue

you would be able to sum for any "period" selection criteria, using Access'
Totals query. No expression, no changes, just a simple query.
 
thank you very much,

Stefano

Jeff Boyce said:
Stefano

If I understand your table design correctly (using fields to contain period
data), the short answer is "no". The qualified answer is "there may be a
way, with lots of work, but it forces Access to behave as if it were a
spreadsheet, not a relational database, so it isn't a good idea."

Have you considered further normalizing your data? If that same data were
in a table that had two fields, like:

YourTable
Period
DataValue

you would be able to sum for any "period" selection criteria, using Access'
Totals query. No expression, no changes, just a simple query.

--
Good luck

Jeff Boyce
<Access MVP>
Click to expand...
 
Back
Top