To display the number of occurrences where a value in one field is followed by another value in a different field within a specified time frame indicated by a separate date/time field on the table, you can create a query using the following steps:
Occurrence: IIf([Field1]=[Field2],"Yes","No")
This will create a new field called "Occurrence" that contains the value "Yes" if the values in the two fields are the same and "No" if they are different. 6. Run the query to see the results, including a count of the number of times that the values matched within the specified time frame. 7. You can further refine the query results by sorting and filtering the fields as needed.
Asked: 2021-10-26 11:00:00 +0000
Seen: 17 times
Last updated: Apr 26 '22