JJFernandez
Registered User.
- Local time
- Today, 04:09
- Joined
- Oct 29, 2018
- Messages
- 18
Hi all,
I apologize if this has been asked and answered but I have put an honest effort in to find an answer with no luck.
I'm trying to run a query and return records for all "incidents", even when some fields I am interested in are blank (actually a record does not exist).
In this specific case, I would like to see all incidents, the incident type, the Investigating enforcement officer, and a suspect's first and last name. Some of the incidents do not have a suspect. I'd still like to see the incident ID, and investigating officer even when no suspect is tied to the incident and I'm unable to currently.
I've tried using criteria but I'm getting no values returned, I assume because the record for a suspect does not actually exist so saying the field is null doesn't really make sense.
I've attached a screen shot if anyone has an idea of what I'm doing wrong, or if I'm designing the query incorrectly, I'd appreciate it.
I apologize if this has been asked and answered but I have put an honest effort in to find an answer with no luck.
I'm trying to run a query and return records for all "incidents", even when some fields I am interested in are blank (actually a record does not exist).
In this specific case, I would like to see all incidents, the incident type, the Investigating enforcement officer, and a suspect's first and last name. Some of the incidents do not have a suspect. I'd still like to see the incident ID, and investigating officer even when no suspect is tied to the incident and I'm unable to currently.
I've tried using criteria but I'm getting no values returned, I assume because the record for a suspect does not actually exist so saying the field is null doesn't really make sense.
I've attached a screen shot if anyone has an idea of what I'm doing wrong, or if I'm designing the query incorrectly, I'd appreciate it.