Linking or Joining or being able to add across fields

[Mike in Saukville]

First off I have tried to explain as bvest I could on what I am trying to do.
If it is a little long my apologies.

I have made a database in Access 2002. I have finally got the fields listed
and the form setup to my liking. The last step (which is where I need help)
is taking information from one field and adding it to another field and
getting a total.
For example I have a field that I can enter hours for repair work. I am
looking to
be able to enter the number of hours charged back to the repair have it
multplied by our rate and then displayed in the labor charges field. The rate
charge will be the same for each department.. an example is entering 3 in the
labor hours field having it multiplied by say $25.00 p/f and the display the
$75.00 in the total labor field.

I also have a field set up for tracking who the repair can be traked to
which department. I would like to be able to enter either an X in the box
say for engineering. Add or count this as one and then the next time i enter
the value it would display totals for that department.


thanx for the help in advance

 

[Jeff Boyce]

Mike

Everything starts with the data.

Please provide a description of your tables/fields, possibly like:

tblPerson
PersonID
FirstName
LastName
DOB

I may be reading too much into your description, but it sounds like:
1 - you have multiple fields for "amounts", and
2 - you are trying to store a calculated value
Neither of these, if true, is desirable in Access.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mike in Saukville]

Jeff,
Here is a list of the fields I have created

Tracking #
Customer Name
Sales Contact
Origianl Order #
Serial #
RGA #
Breif Descirpiton
Detailed Description
Detailed Description -Contd
Notes
In House Labor - Hrs
In House Labor - Charges
In House Material - Quanity
In House Material - Charges
In House Total
Special Order - Type
Special Order - Charges
On Site - Labor
On Site - Material
Site Total Other - Specify
Paint
Mech
Eng
Elec
Elec Total
Eng Total
Mech Total
Paint Total
Other Total
All Total


Here are the Fields I am looking for help with.
In House Labor - Hrs I want to be able to input the number of hours and have
In House Labor - Charges the total charge displyed in this field
In House Material - Quanity
In House Material - Charges
In House Total I want to have this total the In House Labor charges

and the In House material charges
Special Order - Type
Special Order - Charges
On Site - Labor
On Site - Material
Site Total
Other - Specify
Other Total

In these fields I want to place a default character an X for example into
theses fields. And the "X" equal to 1. Then have it add this number to get
a running total for each catagory field.
Paint
Mech
Eng
Elec
Elec Total
Eng Total
Mech Total
Paint Total

All Total Iwant this to display a running total for the different type of
repairs

Hope this helps

 

[Jeff Boyce]

Mike

From your description, you have a ... spreadsheet! A well-normalized
relational database table would not have repeating fields (Amt1, Amt2, Amt3,
....).

Why bother, you ask?

With your design (or a spreadsheet), any change to the categories (add a new
one, take three away, change one) requires changing the table structure, any
queries that depend on the table, any forms that depend on the table, any
reports that depend on the table, any macros that ... (?get the idea).

One of the advantages to a well-normalized design is that adding a new
category only requires adding another row to a table -- no re-design work
necessary!

Regards

Jeff Boyce
Microsoft Office/Access MVP