diferentiating feild n control for a report total

[LNSdataclerk]

how do i set up the report to show the calculated values of each month from
the table so I have a total number showing for each ID in my reports. The
help keeps saying to open table in pivot view? Please help asap

 

[Duane Hookom]

Can you tell us what you are attempting to do with what? Do you have a
crosstab query by month that you are attempting to display in a report? If
so, please share the SQL view of your query and any filtering/criteria
information.

 

[LNSdataclerk]

I am tracking attendance for students. I need to have a daily a monthly and a
year to date toatl for each students attendance. The data base was set up by
someone else. I am trying to modify that data base to do what we need. Thus
far it tracks monthly attendance but can not generate a report to show
anything else. The form attached to the table further does not update the
totals and will not show the total on the report. Is there any way around
this or do I have to atart from scratch?

 

[Duane Hookom]

I don't know anything about how you are storing your attendance records so I
can't answer your question. If you want less vague answers, you need to
provide the significant information.

 

[LNSdataclerk]

IN the table there are feilds that contains a value (monthly toatl
attendance for that record ( being that student) ) for each month of the
school year. then there is a feild that follows stating total attendance for
that record/student. This feild was set up to display the total of all
months for that individual record. But the feild does not calculte even
though the same selection in the form veiw updates and shows the calculated
value ( of attendance) for each individual record. See the total is
important for generating a report and query to show us the total amount of
days that each student/record has year to date. But these values do not
carry from the form to any other part of the database. I want to be able to
track and report daily monthly and year to date attendance without having to
create a new database. Is that a little more detailed? Can you help?

 

[Duane Hookom]

Could you just type the table structure like:

tblTableName
===============
StudentID
Field2 Date/Time
Field3 Numeric
.....

It sounds like someone create a spreadsheet, not a relational database.