Capture Date a Task is 100% Complete

[freidaf]

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.

 

[Ranman256]

no, if its a calculated virtual field, you do not create an actual field.
Always calculate via query.

 

[MarkK]

There is no date/time data in your expression. Is there date/time data in the table from which the calculation of SumOfInserting is made? If that is an aggregate query, I would expect you find the Max([DateTime]) and use that, along with Sum([Inserting]) to return the last date in the range of values that were summed.
hth
Mark

 

[freidaf]

Thank you both for your replies.

I do have a date field in my table. I think I need to re-think my query and add a field with a running sum by day. Then I can determine the date that the file reached 100%.

I am going to give it a try. Thanks so much for your help!