****911 Help - Formulas and Subforms

G

gmaccp

I know Excel but Access has me stumped. I took on an Access project an
it started out great, but that relief did not last long.

I need to be walked through a project. I don't think it is that big,
just don't know how to do it and reading is not helping.

I did the form, but it needs subforms to do calculations and I a
completely lost. I even have the BIBLE. :-
 
D

Duane Hookom

Subforms are generally used to display "child" records related to the
"parent" records on the main form. Can you tell us what kind of calculations
you think you need to do on a subform?
 
G

gmaccp

I believe it is fairly simple.

It is a form that would be utilized to perform audits. I created th
form. The catch is that the series of 20 or so questions that woul
need to be answered are assigned a weight contingent upon the answer t
the question. These weights need to be tallied and displayed on th
form. I have no idea, even after looking through the BIBLE, on how t
do this. I know I probably need to use sub-forms, but I am an Exce
person, not an Access person
 
D

Duane Hookom

Do your 20 or so answers each create a separate record or are they all
fields?
 
G

gmaccp

I think each one is a field. A record would be the line of data? Thes
answers are fields within the record/line of data. Is that a problem?

I just tried to enter a screenshot for you, but it would not work
 
J

John Vinson

I believe it is fairly simple.

It is a form that would be utilized to perform audits. I created the
form. The catch is that the series of 20 or so questions that would
need to be answered are assigned a weight contingent upon the answer to
the question. These weights need to be tallied and displayed on the
form. I have no idea, even after looking through the BIBLE, on how to
do this. I know I probably need to use sub-forms, but I am an Excel
person, not an Access person.
Click to expand...

What is the structure of your table? Is each question in a different
field (tempting but a bad idea) or in a related table, one record per
question?

Don't jump to Forms too soon. Forms don't contain data; they are just
tools, windows that let you manage data. Get your table and query
design working FIRST and then let's see about the form!

John W. Vinson[MVP]
 
G

gmaccp

Oh wow! It sounds as if I put the cart before the horse. Are you fo
hire? As I stated in my earlier email, I think I am lost. I took o
the challenge, so I have to deliver. Would you be able to assist me
or could you direct me to someone who is easily accessbile, John W
Vinson[MVP]
 
J

John Vinson

Oh wow! It sounds as if I put the cart before the horse. Are you for
hire? As I stated in my earlier email, I think I am lost. I took on
the challenge, so I have to deliver. Would you be able to assist me,
or could you direct me to someone who is easily accessbile, John W.
Vinson[MVP]?
Click to expand...

I'm pretty busy right now but for a quick job I should be able to
help. Send your email address to jvinson <at> WysardOfInfo <dot> com
and I'll send you my terms and resume.

John W. Vinson[MVP]
 
Top