I am constructing a database for a taxi company that needs to report monthly for billing. The LNAME group has a users last name, first name, MI and ID number. The next detail section has the details of each trip. The Last name footer summates thefees per person.
When I run the report, the detail section combines all trips for individuals with the same last name and omits any reference to a duplicate last name or first name for that matter. Say lastname is Anderson, I need a report foreach person but it merges the data for say the users Anna, Annie, & Betty etc. and I cannot figure out how to tell the report not to combine the data. I can email what I have should someone need to see the data. Thanks