Good Afternoon Everyone,
I'm using a query with a lot of calculated fields. The stumper for me is how to calculate a date difference between the current record date and the previous record date within the same record set.
query name: qryProjectionEventsAll
record set: PROJID (Linked to Main Event)
field name: d (date value)
Any help is greatly appreciate.
Kim
I'm using a query with a lot of calculated fields. The stumper for me is how to calculate a date difference between the current record date and the previous record date within the same record set.
query name: qryProjectionEventsAll
record set: PROJID (Linked to Main Event)
field name: d (date value)
Any help is greatly appreciate.
Kim