 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / June 2004ACCESS 2000 Question
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. 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 > 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. >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 [quoted text clipped - 19 lines] >> 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.