Summary of information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am learning how to use Access, and need to find the best method to summarise and total data in a report. I need to separate the data from a query by the data in a field and print the total value for the associated reocrds into a summary of the categories.
 
You lost me when you stated "separate the data from a query by the data in a
field".

Could you take the time to enter a few records into a reply as well as the
desired display in your report footer?

--
Duane Hookom
MS Access MVP


dorchfc said:
I am learning how to use Access, and need to find the best method to
Click to expand...
summarise and total data in a report. I need to separate the data from a
query by the data in a field and print the total value for the associated
reocrds into a summary of the categories.
 
Maybe that wasnt the best description of what i want to do.
Here is an example.
Category SubTotal
Training: T&C £1000
Training: Install £1200
Manuals: T&C £ 900
Manuals: Training £1500

Several of the fields have been removed fro clarity, but what i want to do is create a report that Totals all entries containing Training in the category field and displays the total, as well as the total for all entries containing Manuals in the category field.
Finally in the report footer I will add a Grand Total box to show the overall cost (I know how this is done)

Does that help to clarify the problem?
 
Does your Category field contain both the category and subcategory? If so,
can you split this into two separate fields to allow grouping by category or
subcategory in your report?

If you can't create new fields, you can create calculated fields for
totalling on:
=Left([Category],Instr([Category],":"))

If you need more help, maybe tell us if the data your provided is detail or
summary information and if it is what you expect and where you expect it.

--
Duane Hookom
MS Access MVP


dorchfc said:
Maybe that wasnt the best description of what i want to do.
Here is an example.
Category SubTotal
Training: T&C £1000
Training: Install £1200
Manuals: T&C £ 900
Manuals: Training £1500

Several of the fields have been removed fro clarity, but what i want to do
Click to expand...
is create a report that Totals all entries containing Training in the
category field and displays the total, as well as the total for all entries
containing Manuals in the category field.
Finally in the report footer I will add a Grand Total box to show the
Click to expand...
overall cost (I know how this is done)
 
Back
Top