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]

Re: ACCESS 2000 Question

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" <kailey11@aol.c om> wrote in message
news:2004060918 5239.06380.0000 0738@mb-m12.aol.com...[color=blue]
> This probably is a basic question for most of you, but I am setting up an[/color]
very[color=blue]
> simple database - person, date traveled, location and milage - using[/color]
ACCESS[color=blue]
> 2000 and I want to add up the milage in one field so when I do a query on[/color]
each[color=blue]
> person I can print out a report giving their total milage for the time[/color]
period.[color=blue]
> I have been pulling out my hair over this one. Any help MUCH appreciated!![/color]
My[color=blue]
> books on ACCESS 97 don't seem to address this. I have tried =Sum to no[/color]
avail.

[Kailey11]

Re: ACCESS 2000 Question

>You have at least two choices: sum in a totals query and use the totals[color=blue]
>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" <kailey11@aol.c om> wrote in message
>news:200406091 85239.06380.000 00738@mb-m12.aol.com...[color=green]
>> This probably is a basic question for most of you, but I am setting up an[/color]
>very[color=green]
>> simple database - person, date traveled, location and milage - using[/color]
>ACCESS[color=green]
>> 2000 and I want to add up the milage in one field so when I do a query on[/color]
>each[color=green]
>> person I can print out a report giving their total milage for the time[/color]
>period.[color=green]
>> I have been pulling out my hair over this one. Any help MUCH appreciated!![/color]
>My[color=green]
>> books on ACCESS 97 don't seem to address this. I have tried =Sum to no[/color]
>avail.[/color]

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.