How to show the Sum by grouping in Report?

[henrypotter]

Hi All,

I am pretty new to the Report Function of Access. I would like to know how I could how the Total of a particular column grouped by a few categories. I tried searching it in Help and not be able to find it.

Thanks a lot for your help!

 

[HiTechCoach]

You can use the grouping and crate a group footer. In the group footer place a test box with the control of =Sum([YourFieldName]). You do not need to place anything in the detail section unless you want the detail.

You caoudl aslo use a Totaling query to get the totals.

 

[henrypotter]

Thanks HiTechCoach,

Could you tell me if it is possible to just show the total with the individual record details? Or should I make a query separate to achieve this?

Thanks!

 

[HiTechCoach]

Thanks HiTechCoach,

Could you tell me if it is possible to just show the total with the individual record details? Or should I make a query separate to achieve this?

Thanks!

I am not sure what you mean.


The "individual record details" are in the detail section. You "show the total" in the footer sections.

If all you want is the totals, then you can also include a text box to display the vaule od the field you are grouping on fo the sum.

 

[henrypotter]

HiTechCoach,

I see. All I have to do is hide the detail section.

What I am working on is a project to track what asset has matured and what asset was newly purchased by comparing two database files.

I am an EXCEL VBA programmer but not familiar how to write VBA in Access to achieve the above problems. I dont' even know how to start and how VBA in Access interact with its database. Could you please shed some light on it?

Thanks a lot !

 

[HiTechCoach]

Access's Reports Designer is very powerful. I even use the report designer in Access to create reports based on data in an Excel workbook.

See Sprucing Up Excel Data with Access Reports

Also check out: Access Basics

 

[henrypotter]

Thanks.

For my problem, you recommend me using Excel as the database and generate report using Access? I thought Access is better in handling data especially when I need to link two tables.

What you are suggesting seems to be the reverse?

 

[HiTechCoach]

Thanks.

For my problem, you recommend me using Excel as the database and generate report using Access? I thought Access is better in handling data especially when I need to link two tables.

What you are suggesting seems to be the reverse?

My bad.

I though your Access report question had already be answered and you were going on.

Your next question was:

I am an EXCEL VBA programmer but not familiar how to write VBA in Access to achieve the above problems. I dont' even know how to start and how VBA in Access interact with its database. Could you please shed some light on it?

I was trying to answer the new question. It was just a FYI.Not related to the original post.

I was not trying to recommend using Excel. Since you said you were a Excel person, I was just letting you know that using Access reports with Excel can make some great reporting from Excel data.

I generally store all my data in database (Acess/SQL server, etc). I analyze it with Excel.