Summing for a report

[llively2]

I have a table named tblNumberServed with:

Client#
Month1
Month2
Month3
Month4
Month5
Month6
Month7
Month8
Month9
Month10
Month11
Month12

I am trying to make a report that the user can select:

Single month, multile months and have it sum the numbers served for
each selected month and a grand total for the entire months selected.

___________________________________________

Header: Number Served as of ## / ## / ####

Body:
Jan 1,523
Feb 1,235
March 938
_____
Total served 3,696

Footer:

Thanks for your help

 

[Allen Browne]

You must redesign this table so that each month's figures are stored in a
different record rather than in fields of one record. The report you want
will then be child's play.

Whenever you see repeating field names such as Month1, Month2, ... it always
indicates that you need to use a related table for the values. I would
probably use a date/time field using the first date of the month for this
table, so the fields would be:
ClientID relates to the Client table's primary key
TheMonth date/time field.
NumberServed Number

 

[Joseph Meehan]

Read and heed what Allen has said. It will save you many times over.