I have a table that contains a number of Defect and there are a number of fields that I need to filter to give me a count, which will be the basis of a dashboard that will show annual and monthly data over the next few years. Please refer to attachment.
In short, once each record/defect has been completed the defect status is set to "Defect – Resolved". At this time I need this newly completed defect to automatically update the count of the dashboard form. I need to use the following combination of fields to filter the data that will be a count for the Jan 2020 text box, against the correct "AFE" or "Emergent" and against the correct defect category.
I tried the following as a start, but I am unable to get it to work.
=Count(IIf([tbl_Defect_List].[Month]="Jan",0)) And where([Risk_level]=[”Low”],0)
[Year]=”2020”
[Month]=”Jan”
[Risk_level]=”Low”
[Expenditure_Type]=”Emergent”
[Defect_Status] = Defect – Resolved”
Any help would be greatly appreciated.
Cheers Mick
In short, once each record/defect has been completed the defect status is set to "Defect – Resolved". At this time I need this newly completed defect to automatically update the count of the dashboard form. I need to use the following combination of fields to filter the data that will be a count for the Jan 2020 text box, against the correct "AFE" or "Emergent" and against the correct defect category.
I tried the following as a start, but I am unable to get it to work.
=Count(IIf([tbl_Defect_List].[Month]="Jan",0)) And where([Risk_level]=[”Low”],0)
[Year]=”2020”
[Month]=”Jan”
[Risk_level]=”Low”
[Expenditure_Type]=”Emergent”
[Defect_Status] = Defect – Resolved”
Any help would be greatly appreciated.
Cheers Mick