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.
2  1352 
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.c om> 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.
>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.c om> 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Scott Simonson |
last post by:
I have a client that has asked me to modify an existing Access MDB. My
question is they want me to populate their SQL server(2000 I believe). How
can I accomplish this in Access 2000? Are there things I should be aware of
first?
Another question, where can I get a copy of SQL server to test with? Isn't
there a "personal" version I can attain for development purposes? It seems
ridiculous for me to have to "buy" SQL server for testing...
|
by: Maur |
last post by:
I have Office XP Pro and Developer Edition and SQL Server
installed on my local development machine.
Given the option of installing;
Visual Studio 6.0 Enterprise Edition
AND/OR
Visual Studio.NET Enterprise Architect Edition.
|
by: Sean Howard |
last post by:
This is not a question, but I need a bit of advice.
I need to create a software solution for users in various countries.
Normally I would use Access 2000 and simply deliver the databases for
use. Unfortunately some of the users will not have Access installed on
their machines, and will not purchase it simply to use this software.
In the (bad) old days of using Access97, I would have simply sent the
databases together with the runtime...
|
by: Squirrel |
last post by:
I've developed an Access 2002 database which will be deployed with the
backend on
a server and frontend on the users' PCs. I've now been advised that new
employees will
be given laptops with Access 2003 installed and that the server software
will not be
updated. Also some of the users are using Access 2000 and some Access 2002.
My question is - will this work? There is a lack of IT support in this
department - they've
contracted with...
|
by: DonLi |
last post by:
Hi,
I have a copy of Access 97 while my client uses Access 2000 which
supports Unicode. My client has ordered a copy of Access 2000 upgrade
for me, but the middleman, atomicpark.com is totally ABSURD, first
they delayed delivery and secondly when they sent the ordered product
they sent me a badly damaged CD, when I asked for replacement they did
not even bother to apologize instead telling me to contact them. I
don't ever ever want to...
| | |
by: Michael |
last post by:
I am using MS Access 2000 on an Windows XP machine and am trying to
use
the Upsizing Tool in Access 2000 to upsize an Access 2000 database to
use with Microsoft SQL Server 7.0.
My MS Access 2000 version is part of an Office 2000 Developer Edition
upgrade from Office 97. Included in the Office 2000 SR-1 Developer
package is a disk entitled Microsoft SQL Server 7.0 that I have
installed.
|
by: Serious_Practitioner |
last post by:
....or lack thereof...
I use Access 2000 which I own as part of Office 2000 Professional. I've had
enough trouble with glitches to ask if these are common occurrences -
1. Sometimes the "Help" system won't start. Sometimes it will. It starts
more often than not. I don't see any
pattern to when it does or doesn't. If the Access "help" won't start,
the Visual Basic "Help" usually won't
start either. This glitch has been going on for...
|
by: stu |
last post by:
I have several databases that are opened using various versions of
Access and VB. Up till recently everything worked fine, then I started
getting a variety of lock file error messages, both on my PC and other
computers (both Win2k and WinXP).
After a lot of testing I found that if the database was opened by
Access 2.0 (or a VB3 16 bit application), and then subsequently a
Access 2000 (or VB6 32 bit application) opened the database, then...
|
by: lcifers |
last post by:
First off, sorry if my cross posting offends anyone. I'm posting this
in Access and SQL Server groups - not sure which one is appropriate.
I have a relatively simple ASP.NET/VB.NET application that is now
hitting an Access 2000 database over an intranet. We have to migrate
the database to SQL Server 7. My experience with ASP.NET is pretty
limited and my experience with SQL Server is nonexistent.
We have an MSDN subscription, so I went...
|
by: Mathieu Trentesaux |
last post by:
Hello
I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button remains desperatly grayed.
It also seems impossible to open the library in another Access instance
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
