Help with a Calculated Field

[aball65]

Hello,

I have a form called RISK that pulls data from a table called RISK. I want to display a calculated field (read only) on the RISK form which represents the sum of the following table fields:

R_COST_IMP.value
R_SCHED_IMP.vaue
R_PERF_IMP.value

The following foreign keys link the R_COST_IMP, R_SCHED_IMP and R_PERF_IMP tables to the RISK table:

RISK.rci_id -> R_COST_IMP.rci_id
RISK.rsi_id -> R_SCHED_IMP.rsi_id
RISK.rpi_id -> R_PERF_IMP.rpi_id

Any ideas would be greatly appreciated!

 

[RuralGuy]

Have you tried adding those tables to the query for the RISK form RecordSource?

 

[aball65]

I did that and the form now recognizes the R_COST_IMP, R_SCHED_IMP and R_PERF_IMP fields. Thanks! Now, how do I define the control for my summary field? =[R_SCHED_IMP].[Value]+[R_PERF_IMP].[Value]+[R_PERF_IMP].[Value] doesn't work. Sorry, I'm an Access newbie...

 

[hiền muội]

Hi aball65,
I want to know what's the data type of the R_COST_IMP, R_SCHED_IMP and R_PERF_IMP fields you designed? is text or number?
Example textbox is sum field

+case number: control source is: =R_COST_IMP+ R_SCHED_IMP+R_PERF_IMP.

+case text: control source is: =val([R_COST_IMP])+val([R_SCHED_IMP])+val([R_PERF_IMP])

 

[RuralGuy]

Try the following:
=[R_SCHED_IMP]+[R_PERF_IMP]+[R_PERF_IMP]

 

[aball65]

Thank you very much!