I have a database set up for time sheets. Each entry has PW at all times and may have a CPSB number if one has been assigned. When I run my a basic query to pull back all the information I get all the time sheet entries (6809). Now when I try to add in to add in the account numbers (which not all entries will have an account number) that is pulled from a different table but is linked by the PW, it does not return all of my results. It is not pulling back entries that have a null for account number. I have even tried to set my criteria as "is null" and that pulls back nothing. Any ideas other than adding a new field to my main table and entering the account numbers that way.