D
deekaye
Hi
I have a list of contacts in a contacts table and list of activities
in activities table that includes all interactions with each client.
In each activity their is a 'status' field. I need a way to bring up
the latest 'status' field value for each contact. The latest would be
the one with the latest 'log date' (a field in the activity table).
What makes things tricky is that status is not a required field, it
only gets filled in when the status of the contact changes, so for some
records status may be blank. I need the latest (ie latest log date)
status value that excluding all blank entries.
How would I bring this up in a query?
I have a list of contacts in a contacts table and list of activities
in activities table that includes all interactions with each client.
In each activity their is a 'status' field. I need a way to bring up
the latest 'status' field value for each contact. The latest would be
the one with the latest 'log date' (a field in the activity table).
What makes things tricky is that status is not a required field, it
only gets filled in when the status of the contact changes, so for some
records status may be blank. I need the latest (ie latest log date)
status value that excluding all blank entries.
How would I bring this up in a query?