Query using inventory

[Porksword]

I can't figure this one out. I am trying to create a query that will list which games have been rented out, how many are in total, and how many available. I am trying to sort by category so I can eventually make a Form. My biggest fear is that I don't have my tables or relationships correct. I also want to make a query/form to show which games have been rented out for 6 or more months. Help would be much appreciated.

Thank you,


Steve

[Porksword]

*bump*

I know you pros out there can help me with this.