Total From Query to Report

[bigredseany]

Hi, I am new to access and I am trying to create some kind of inventory database for my uncles company.

Not sure how to explain this, I am trying to just 'link' the total from the bottom of the query into my report. The report is going to contain many totals from different queries, and then I also need a to get a sum of all the totals.

Also, this is not as important as the main question, but how is Access used in the industry? would every workstation have a copy of Access?

I use Access 2007
Windows XP


Thanks.

[bigredseany]

bumb !

[maxamis4]

Well there are many ways you can do this. My first question is does your report have all the values you will be using inside of it, or do you need to recreate additional calculations outside of the report which should be included in the final report?

Keep in mind that you can create the soure of your report with all the variables it will need by dictating the control source of the report. the control source is just another quiery in which you can define all the values it will need to use.

I need more information about your report to assist you any further. Such as what type of caluclations where they come from and that sort of thing.


Good luck

[bigredseany]

When I click the Totals button, it creates a footer with different options. I choose Sum, and I need to link that number into my report. I need to do this many time (around 15) and then I need to create a grand total (Adding all of the totals together).

I am a Computer Programmer, and have finished a systems analysis and design class last year, and the class covered access but didn't really teach us how to do anything on our own, we just followed step-by-step instructions.

[garethfx]

[quote=bigredseany]When I click the Totals button, it creates a footer with different options. I choose Sum, and I need to link that number into my report. I need to do this many time (around 15) and then I need to create a grand total (Adding all of the totals together).

I am a Computer Programmer, and have finished a systems analysis and design class last year, and the class covered access but didn't really teach us how to do anything on our own, we just followed step-by-step instructions.


First off does each product have ONE in hand value in your databse OR are you using multiple entries and adding then together in the query to make the gross total.

Assuming that each product code HAS one in hand value and you want to show each value as a total on a report, Then make One query, pull all the products together with that and set the report to to show each value !

[maxamis4]

Inside the reports you can create a variety of groups in order to group all your values inside the report. If you click on the report properites and view the groups you can specificy all the different groups and summarize them in that fashion. Further more you can take the report summary at the end of the report and summarize all your groups into one total.