Solved a Problem with a report when I delete a data in a specific fileds

[Hamatto]

Hello friends, thanks a lot for your help.
there is an attachement file I have a problem in it and don't know why it is happen
In tbl_Sheet, When I left Gade Field without any data(for Ramy) Ramy doesn't appear (with his rest data)in the report.The same Happen with Tohanda But when I left Lagna_n without any data, too.
but when I left Class field OR Gloss No. field for Melga and Sozanna they appear normally in the report with their rest data
Why Grade and Lagna_n fields make this problem and not Class and Gloss No. fields?
Please Help me I want when I left any field without data the names appear normally with the rest data in the report without change the relations between the tables
Any help will be appreciated
Thanks a lot for you all

 

[Gasman]

Because of your query?
Your joins are wrong for what you appear to want.

 

[Hamatto]

Please , may you explain that for me . On the attachement file?
I am sorry I didn't understand

 

[Gasman]

Look at each option and see if you can see the issue.
See if you can glean any info from @Pat Hartman 's post

SQL Join Types

I built a teaching database for a class I'm giving and I thought I'd share a part of it with you. This is a report showing all the join types with SQL and a Venn diagram to help you to understand what the join is really doing. Let me know if you like the presentation. I included a pdf so you...

www.access-programmers.co.uk

 

[Hamatto]

Thanks a lot, my friends gasman and Pat Hartman for your help and patience with me
Now, I understand it
Pardon me for my many inquiries, because I'm almost new to learning Access
Have a nice time