I'm trying to build a database for all our customers that includes a labor charge, service call charge, parts charge and a grand total. I'm pretty good in math, but to avoid errors, I'd like to make the grand total column automatically compute the sum of the previous three columns. Is this possible, and if so, please explain how to do it, and please, keep in mind that I've never used access in my life.
7  2196 
Oh, and I'm using Access 2000
Hello,
first off this is possible, but you have to ask yourself a couple of questions. Are you trying to create this input - output to display on a form, print out in a report, show only on a table, or a combination of all the above?
If you can answer these questions it will help us to find a solution for you easier :)
Just on the table. It's a very small database, only for repair customers. I actually have not built any reports or forms yet.
Hello again,
Well it would be very long and confusing im sure if i explain how to do this so i just built a simple db for you to learn from. What i did was create a sample table with dummy numbers in it. Im guess that each field would contain money values, based on the types of fields you were using. Next i built a small query that runs a calculating expression to total up the numbers from your table.
you can play with the table and put in any dummy money amounts then save the table. Then all you have to do is open the query and it will calculate it for you.
I hope this helps.
Thanks, I think that will do the trick
NeoPa 32,569
Recognized Expert Moderator MVP
Nieru,
You really don't want to store this value to your table as that would only be creating a rod for your own back (See Normalisation and Table structures for why).
Instead, simply use a query any time you need it and have the value worked out in the query. Something like : - TotVal: =[FieldA] + [FieldB] + [FieldC]
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: cwdjrxyz |
last post by:
Javascript has a very small math function list. However there is no
reason that this list can not be extended greatly. Speed is not an
issue, unless you nest complicated calculations several levels deep. In
that case you need much more ram than a PC has to store functions
calculated in loops so that you do not have to recalculate every time
you cycle through the nest of loops. Using a HD for storage to extend
ram is much too slow for many...
|
by: Lauren Wilson |
last post by:
I'm having trouble with the Access VBA help on my installation of A2K
with Dev tools. Every time I try to retrieve help for items listed in
the Object Browser (and SOME other items as well), Access tells me
that the "feature is broken" and prompts me to repair it. When I do
so, it goes through the motions but does NOT repair the help files.
Anyone have a clue about this problem?
|
by: Ingmar |
last post by:
Simple comparison tests we have performed show that System.Math
functions in C# are much slower than corresponding functions in C++.
Extreme examples are System.Math.Exp() and System.Math.Tan(), which
both seem to average 50 times slower than their C++ counterparts.
(Tests are done using optimized Release configurations outside the
Visual Studio environment.)
Our explanation for this large discrepancy is that C# is an
interpreter...
|
by: TC |
last post by:
I have an Access database application with a lot of custom row
functions written in VBA. In other words, a lot of queries contain
calculated fields which use functions defined in the modules.
I am now thinking about upgrading the database from Access to SQL
Server. If I do, how can I implement the custom row functions? Is
Visual Basic integrated with SQL Server just as it is with Access? Or
does T-SQL in SQL Server offer the...
|
by: Mike |
last post by:
can anyone explain to me why, given:
decimal dec = 84.50M;
Convert.ToInt32(dec).ToString()
and
Math.Round(dec,0).ToString()
both correctly output "84"
| | |
by: markaelkins |
last post by:
In the code below I’m trying to figure out how to dynamically perform math
functions in a form. To start, I would like to subtract
TxtITotal.Text from TxtPTotal.Text and display the results in
TxtProLoss.Text before sending the data to the database. I have no
idea where to begin.
Any help would be greatly appreciated,
Thank you,
|
by: kai |
last post by:
Hi,
How to find the list of SQL math functions in SQL Server 2005?
Thanks
Kai
|
by: Ney André de Mello Zunino |
last post by:
Hello.
The following program:
#include <list>
#include <iterator>
#include <algorithm>
#include <cmath>
#include <iostream>
|
by: Chad |
last post by:
I'm want
static char *output;
to hold the modified string "tel chad"
However, when I debug it,
static char *output
holds the ascii value of the strng, and not the string itself.
Here is what I have. I know gets(), strcat strcpy() shouldn't be used.
|
by: Nondisclosure007 |
last post by:
Hello. If this is the wrong group for this, please let me know.
I'll
post it somewhere else.
I've been doing data imports into MS Excel (ver 2007) and using the
CORREL function. What I was wondering was is there anything like
this
in Visual Basic or C#? Or even a DLL? I've got VS2008 and I really
don't want to code the CORREL function by hand if I can just pass off
2 or more array's to a function that already exists.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |
