OK, so at work I have an Access database that has all the employees in it. It also has all the incidents (injuries, car accidents, etc...) in it. It's organized like this: So, I have a query that should include all the people hired before a given date, and all the incidents that people have had since a certain date. So, the way I have it setup right now, it includes all the records from the employee table, and all the records in the incidents table that have a date later than a given date. The trouble is, if a person has an incident that occurred before the given date, rather that just having the person show up without the incident, the person just doesn't show up at all. I need that person to show up, but without that incident beside their name. So, c'mon all you Access/SQL masters, tell me how to get Access to do this or give me some fancy SQL statement that will do this for me (I know some SQL, but I'm no expert).