Hello,
I need to capture the date that a calculated field in my query equals 100%. Then, once the field equals 100%, I want the results to show up in my query for 1 day after the date that the file reached 100%.
This is my calculated filed:
PercentCompIns: IIf([SumOfInserting]>0,([SumOfInserting])/([FI_InpAccounts]),0)
I am assuming I need to add another calculated field to the query to capture the date the "PercentCompIns" field equals 100% but I'm not sure how to do this.
Thank you for your help.
I need to capture the date that a calculated field in my query equals 100%. Then, once the field equals 100%, I want the results to show up in my query for 1 day after the date that the file reached 100%.
This is my calculated filed:
PercentCompIns: IIf([SumOfInserting]>0,([SumOfInserting])/([FI_InpAccounts]),0)
I am assuming I need to add another calculated field to the query to capture the date the "PercentCompIns" field equals 100% but I'm not sure how to do this.
Thank you for your help.