I'm in need of a report that can show info from multiple unrelated tables, basically I need to combine all sales with the pickups and payments for a person I select and be able to print it all off, all my information is stored where it has a buyers name column I should be able to use, but I'm fairly new to access as I was working with excel before this. I would love it if someone could explain how I could make a totals row for all this information as well.