I have one table that is customer info and purchase info.
I created a query that is the sum of “totals” from the first table and in it is a table that has that info.
When I write the report I have no problem but only one table is listed and I need the info from the second table to be available to the report also.
It sounds as if you need some help using a JOIN. These links may help:
https://help.libreoffice.org/Common/Join_Properties