Query not pulling all users

[Listerman]

So the users table has 33 individuals.
When I run my query it only pulls 29 individuals.

I have found that the reason is because in 1 table 4 users dont exist because they have no records or statistics in that table. My join is already set to show all users in the users table and matching records from the stats table but it will not show the 4 users for anything.

Also have to take into affect that the criteria is searching for a specific month in that table. If i run it for February it works fine, if I run it for April 4 users are missing because they have no stats for April.

Any ideas on show their username even if they dont have data in the stats table?


Thanks again

 

[georgedwilkinson]

If I understand you right, you need to do an outer join on your query.

Display your query in the grid and right click on the relationship, select "Join Properties" and select either the second or third option, based on your need. If you don't know which one to select, try them both one at a time until you get the result you want.

Feel free to ask a followup question. I know this stuff can be daunting at times.

 

[Listerman]

i have setup an outer join but seem to have the same issue.

i believe the issue is coming from the table that is between user info and statistics, which is usernames.

The user info contains their basic contact info.
Statistics contains their stats for that month.

The table between them is a username table that stores 5 user names per user and then one username links to the stats table because that username is how they appear in the statistics table.

I think my error is coming from that table and i should probably just move the usernames into the same table as their user info

any ideas?

 

[georgedwilkinson]

Can you post your database here?

 

[Listerman]

I think I found the reason. For some reason when I import the new data(april) their previous months user data(february) is getting overwritten with the new data, but only for those 4 users.