NSC_24 said:
I would like for a field (Total Visits) to be populated
from the addition of Hospital_1 + Hospital_2 + Hospital_3.
If those three fields are all in the same record, you would not want to
populate yet another field with the total -- you would want to use an
expression in a Query to calculate the total when you retrieve the
information for display to the user. It is not good practice to give your
users access to datasheet view or tables or queries, because that makes it
so easy for human error to corrupt your data.
Also, it will likely make your life easier if you would create a related
table with information about hospital visits rather than having a count for
specific hospitals in the same record. As you have it designed, what do you
do when you add a fourth hospital to your resources? Looks like you'd have
to re-design. With a related table you'd just add another data value option
to the "hospital id" field, and record the visit.
Would I be able to use a macro or query so that this occurs
automatically?
With macros and/or VBA code, _almost_ anything is possible. But, because I
suspect you need to redesign, I would not want to help you move farther away
from that good design.
Larry Linson
Microsoft Office Access MVP