Report from 2 tables

[KWarzala]

I have 2 tables: tblLocations with Type (has store locations and whether they are a food or merchandise location) and tblBreakdown (has the date, Location, and the amount of money spent at the location) I am trying to make a report that shows all the store locations (even if no money was spent there) and be able to pull up the report by month and see what dates something was purchased from the store. Basically right now, there is a paper checklist for each month which has all the locations on it, and when something is purchased at the store it gets highlighted, so it is easy to see which one's haven't been visited in the month. I can make a report that shows the location name, and when it was visited, but it wont show the locations that haven't been visited. i don't know if this makes sense. thank you!

[RuralGuy]

Assuming you can join these two tables you need to use a Left Join instead of an Inner Join.