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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top