Total Sum of a column in tabular view

[Jaishree Jaidev]

Hi,

I have created a report. The report screenshot is zipped and added.
I have circled the portions for which I want the output.
Is there a function or code in ACCESS where I can get the sum of values in a column.
In the attached image I need the sum of four columns. Is there a way?

 

[MStef]

For Sum on Column, look at "DemototalSumA20022003.mdb" (attachment, zip)
Open form and see. Adapt it in your mdb.

 

[Jaishree Jaidev]

I tried the same but it doesnt seem to work I dont know why.

 

[MStef]

Maybe you make a mistake somewhere.

 

[Jaishree Jaidev]

Or is it because the last column is a sum of few other options.

 

[MStef]

Send a short example of your mdb, (Access2000 or 2002-2003).

 

[Jaishree Jaidev]

Please find attahced the sample database. This is just an example. There are around 104 segments in the real case

 

[MStef]

I can't to read this. It is not Access2000 or 2002-2003.

 

[Jaishree Jaidev]

I have ACCESS 2007. Is there a possibility to convert it?

 

[Jaishree Jaidev]

Please check whether this can be opened

 

[MStef]

No, I can't open it.

 

[Jaishree Jaidev]

Now I don't know what to do?? Can some one give me a clue.

 

[Jaishree Jaidev]

Hi,

The same problem exists... is there a possibility that I maintain the same table structure and then get a sum of a column in a form...

 

[Jaishree Jaidev]

Hi All,

I have a big doubt. Can I create a FORM based on multiple Queries??? IF so please furnish me with the details.