qryReport is correct based upon your SQL. It appears (educated guess) that you want all records for a particular Trip Log. If this is the case, the Where condition is in the wrong place. In the current location it only affect the selection of previous segment records which are joined to another. The where condition should instead be at the end of the entire SQL statement.
As for the Name vs ID of the Accommodations, this was given to you in your last question here → How to return table ID and Name from a linked table in a query and that answer showed a link to where it was provided previous to that question.
Report totals/accumulations can be tedious and difficult depending upon what is being done. The documentation definitely needs to be reviewed → LibreOffice Base Handbook. See Chapter 6 - Reports.
Your sample shows an empty field on the
Page footer. If this was meant to be your attempt at an accumulation, it is not in the proper place. You would want totals on either a
Report footer. Page footers are handy for something like page numbering.
Here are some links to accumulation and calculated fields in reports and a sample on one post:
Accumulation function in base report not working
How to reuse an accumulated value in a Report?
Libre Data - multi-level report