2 values

[Guest]

i have a few experience in access please advice me for the following probelm:

in my database i have total value fields as the total of six fields and i
want to my it either to enter the total as total of six fields or manual
direct to total value .

also, habe a list box fields from lookupwizerd from anther table iwould to
be either to enter to name or from the list box.

 

[Guest]

As a rule, you should not be storing derived values in a table. There are
exceptions, but they are few. Also if you are adding up 6 other fields, you
might have a normalization problem. I highly suggest getting some relational
database training or reading "Database Design for Mere Mortals" by Hernandez
before proceeding any further on this database.

 

[John W. Vinson]

i have a few experience in access please advice me for the following probelm:

in my database i have total value fields as the total of six fields and i
want to my it either to enter the total as total of six fields or manual
direct to total value .

You do not need to store the total, and it should NOT exist in your
table. Just recalculate it whenever it's needed. Storing it wastes
space, wastes time (an addition is MUCH faster than a disk read), and
most important risks data corruption, since if you change any of the
six fields your total will now be WRONG with no easy way to detect
that fact.

also, habe a list box fields from lookupwizerd from anther table iwould to
be either to enter to name or from the list box.

Don't use table Lookups AT ALL: see
http://www.mvps.org/access/lookupfields.htm for a critique.

Instead, use Forms to enter and edit your data; you can easily put
Combo Boxes or Listboxes on the form to display and select values.

John W. Vinson [MVP]