S
Steve in MN
Working on a survey response db. I have 9 survey answers all on the same
record with y/n fields. after y/n is selected for each question some code
runs to update another field in the same record for the weighted factor (ex 5
for yes, 0 for no) for each question. there is also an option for a N/A in
the survey response and that leaves the weighted field null. I need to have
the results show on the form live for imediate viewing, so i have another
field with the total points of the current record updated using a background
update query and stamping that field.
The question comes in to find the potential points possible per survey where
if one of the fields is null, then that wouldn't count in the results. How
do you count fields on the same record but filter out anything that is null?
I know this would have been easier having each question on a seperate
record, but laying that out seemed harder for how it needs to be viewed.
record with y/n fields. after y/n is selected for each question some code
runs to update another field in the same record for the weighted factor (ex 5
for yes, 0 for no) for each question. there is also an option for a N/A in
the survey response and that leaves the weighted field null. I need to have
the results show on the form live for imediate viewing, so i have another
field with the total points of the current record updated using a background
update query and stamping that field.
The question comes in to find the potential points possible per survey where
if one of the fields is null, then that wouldn't count in the results. How
do you count fields on the same record but filter out anything that is null?
I know this would have been easier having each question on a seperate
record, but laying that out seemed harder for how it needs to be viewed.