General discussion
January 15, 2003 at 07:38 AM
matt.mesaros

Acces 2000 Database Duplicate Names

by matt.mesaros . Updated 23 years, 5 months ago

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

This discussion is locked

All Comments