I have the following sql statement.
strSQL = "SELECT RevEntry.OperatorID, RevEntry.RevTypeID, RevEntry.CampaignID, RevEntry.HolidayProgramID, " _
& "RevEntry_Sub.MemberID, Sum(RevEntry_Sub.Pax) AS SumOfPax, Sum(RevEntry_Sub.Bookings) AS SumOfBookings, " _
& "Sum(RevEntry_Sub.Revenue) AS...