Hey guys and gals,
I have multiple tables with absolutely no relationship to each other. They record completely different things, therefore I wouldn't think a relationship is needed whatsoever. The primary key is an ID autonumber on all of the tables.
I'm trying to create a report that will sum one field from each table. I've tried creating a query with a field from each table, for the recordsource. When I run the query however, it lists the same information multiple times. It seems to do this because there aren't the same number of records in each table, so it seems to fill the gaps by just duplicating information.
I'm not sure how to create the query so that I can use it as the record source for my report.