By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,480 Members | 1,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,480 IT Pros & Developers. It's quick & easy.

ACCESS 2000 Question

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
>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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.