ACCESS 2000 Question

[Kailey11]

This probably is a basic question for most of you, but I am setting up an very
simple database - person, date traveled, location and milage - using ACCESS
2000 and I want to add up the milage in one field so when I do a query on each
person I can print out a report giving their total milage for the time period.
I have been pulling out my hair over this one. Any help MUCH appreciated!! My
books on ACCESS 97 don't seem to address this. I have tried =Sum to no avail.

[Larry Linson]

You have at least two choices: sum in a totals query and use the totals
query as the record source of a report or form to see only the totals, or
calculate the sum in the footer of a report. You certainly do not want to
calculate and store the total (redundant information) in a table. If this is
not enough of a help, please clarify where you want to display the totals
and whether you want to display the detail _and_ the total, or just the
total.

Larry Linson
Microsoft Access MVP
"Kailey11" <ka******@aol.com> wrote in message
news:20***************************@mb-m12.aol.com...

This probably is a basic question for most of you, but I am setting up an very simple database - person, date traveled, location and milage - using ACCESS 2000 and I want to add up the milage in one field so when I do a query on each person I can print out a report giving their total milage for the time period. I have been pulling out my hair over this one. Any help MUCH appreciated!! My books on ACCESS 97 don't seem to address this. I have tried =Sum to no

avail.

[Kailey11]

>You have at least two choices: sum in a totals query and use the totals

query as the record source of a report or form to see only the totals, or
calculate the sum in the footer of a report. You certainly do not want to
calculate and store the total (redundant information) in a table. If this is
not enough of a help, please clarify where you want to display the totals
and whether you want to display the detail _and_ the total, or just the
total.

Larry Linson
Microsoft Access MVP
"Kailey11" <ka******@aol.com> wrote in message
news:20***************************@mb-m12.aol.com...

This probably is a basic question for most of you, but I am setting up an

very

simple database - person, date traveled, location and milage - using

ACCESS

2000 and I want to add up the milage in one field so when I do a query on

each

person I can print out a report giving their total milage for the time

period.

I have been pulling out my hair over this one. Any help MUCH appreciated!!

My

books on ACCESS 97 don't seem to address this. I have tried =Sum to no

avail.

Larry, thanks for your response. I have tried to put the sum in a totals query
but it didn't work so I think I need to add something more. Could you walk me
through this? (Understanding that I am an Access novice.) I thought it would be
easier to add up the milage in the query than a report as I want to run a
report on several people to give them their total milage and I could just
change the name in the query. I want to list every week's milage along with the
total miles in a report.