Need help with creating condition to produce follow-up list in Acc

  • Thread starter Thread starter Smitee2006
  • Start date Start date
S

Smitee2006

I have an incident management database with a separate table for tracking
status of file. Users managing the incidents can select a status type such as
followup, pending investigation, and finally, signed off. I want to see a
listing of all matters which don't have a signed off status selected. There
could be multiple status until the signed off choice is made and I want the
followup report or list to only show the most current status like a checklist
for the person managing the incidents.
 
Can you provide any table and field names? Can we assume the status values
are stored in an incident status history table?
 
Back
Top