Sum

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

i am creating a mileage program and i would like to print
a report

i would like the report to be designed that it sorts the
info in the database by month and then user with a total
at the end of each user and a total at the end of each
month.

the totals are based on a column that has the trip
between each mileage for the user

thanks
 
How far have you gotten with this? Have you started the report and looked at
the sorting and grouping dialog? This allows you to sortgfoup by month and
then user. You can display group footers and include your sums in the
footers with text boxes bound to control sources like:
=Sum(Miles)
 
Back
Top