I have a Table called TblReliabilityProgramme which has 6 Fields that I am really interested in (I know the entire Table has 9 Fields/Columns, but these 6 are the main ones I am interested in):
For a little feature I am trying to create on a Form, I need a way of identifying or triggering on the Form, how many of these Fields have been filled in. For example there are 6 Fields in total, if 4 of these have been filled in, I will want to identify 4/6 have been filled in on the Form. That way I can trigger my FormStatusBar to show a bar that is 4/6 of it's length coloured.
I can currently make this work by creating a Calculated field, but I have concerns that this will massively bloat the Database as Access will be storing this data. I do not plan to use this data for anything else other than showing the completion on the FormStatusBar.
The calculated field does an IsNull and an IIf on each record to give a number for how many have been filled in per record. The attached pic shows the important fields.
Any suggestions on better ways to do/implement this?
- Title
- Intent
- Cost
- Reference
- Frequency
- ConceptionDate
For a little feature I am trying to create on a Form, I need a way of identifying or triggering on the Form, how many of these Fields have been filled in. For example there are 6 Fields in total, if 4 of these have been filled in, I will want to identify 4/6 have been filled in on the Form. That way I can trigger my FormStatusBar to show a bar that is 4/6 of it's length coloured.
I can currently make this work by creating a Calculated field, but I have concerns that this will massively bloat the Database as Access will be storing this data. I do not plan to use this data for anything else other than showing the completion on the FormStatusBar.
The calculated field does an IsNull and an IIf on each record to give a number for how many have been filled in per record. The attached pic shows the important fields.
Any suggestions on better ways to do/implement this?