Using SUM in Access

[kabz]

Am kind new in Using Access
Can someone help me on how I can Sum up some details of my Records.
for Example.Am making database for records who have done certain courses,i indicate by the Check Box if he /she has done that particular course. So how can i SUM up all the records for those who have just done a particular course on the reports for my Database based on my Select Queries?.

thank you.

Kabz

 

[KenHigg]

There are several ways depending on how/where you want to display the data. Will you be doing this on a form or in a report? How many records do you think you'll have to traverse to get the sum (total max you think there will ever be)?

 

[kabz]

well i want to display my data on my reports.
I think i will traverse more than 1000 records

 

[KenHigg]

You should be able to simple put something like the following in a text box in the report footer:

=sum(myFieldName)

ken

 

[kabz]

thanks Ken,that worked.but how can i make another report that shows only these totals

 

[KenHigg]

One way would be to simply use a dsum() function -

ken

 

[kabz]

Ken i used the =-sum([Grade1]) function to have the sum,the problem is am having a number of blank pages before the last page where its showing the totals.The thing is i just want to show one page for the sum on only.
Help me please

 

[KenHigg]

I'm guessing you don't need to even have an underlying recordset (query) defined for the report if all you are going to have on the report is the dsum() stuff

ken