Need more data!

Hey everyone here's hoping you can help me once again. I'm making a report that gives totals of different things grouped by their location. So, I'm trying to make a table that has the locations on the left and then the total for each different thing to the right. I don't want to have to keep relisting the location, but each total comes from a different data set so I tried putting separate tables side by side. Unfortunately if a location has a 0 it won't show up in the query and thus isn't in the data set for the table. Is there a way to link the tables to the locations so that a zero will be displayed if there isn't anything there?

I'm not sure what your query looks like, but if you do an outer join won't the location with 0 show up?

If not, post the query, please...

>L<