I am unable to figure out why a report that selects the data from a query is including the "Invoice Total" from the main table and the "Total" from the detail table. I am using 3 linked tables, one has the invoice fields, one has the detail fields and the other has vendor information. I am only selecting the "Invoice Total" and not the detail "total" but both fields are included in the report. Nowhere in my report layout is the field "Total" included. Can someone explain to me what the heck is going on? I have included a link to a screen capture of the report query so you can be understand what I am saying. My mind and fingers don't always agree when typing my problem.
Any help will be greatly appreciated.
Thanks............Ralph
Here is the link to the jpg screen capture: https://farm4.staticflickr.com/3752/...b74924ee_b.jpg