Result summary in a report

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have the following Filed in an example tabel
Table_Names
Field1 Field2
Name Marks
LSS 20
SM 10
SM 5
CPM 5
SM 20
CPM 10
LSS 5
LSS 30

The marks must be summed to be used in a report in the following way:
LSS = 55
SM = 35
CPM = 15
This must sorted the most on top and the least at the bottom
When a record is added then the summary must also change and if the sort
order change this must change so that it is always orderd as abover
Example.
New record is added in the field
CPM 30
New Summary must the look like this
LSS = 55
CPM = 45
LSS = 35
This must calculated for n number of records entered

This result is must be viewed in a report as
LSS = 55
CPM = 45
LSS = 35 and it must also change as new records are added

Thank you for helping
 
If I understand correctly, you can create a totals query like:
SELECT [Name] as TheName, Sum(Marks) as TotMarks
FROM example
GROUP BY [Name];

Use this totals query as the record source of your report and set it sorting
and grouping main level to Totmarks Descending.
 
Back
Top