Software

Ask something
Discussion Locked

Acces 2000 Database Duplicate Names

0 helpful
13 replies

by matt.mesaros

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

13 replies

by otl

Would be more efficient to have all drivers in one table, trip reports in another, and utilize an unique auto-generated number for the individual drivers id or their id number to be used as the tag for trip details. Then base the report on the id number, never have a duplicate.

by bristar

Try building a query. Create a new column and put the following line in there:
Full Name: [Last Name] & ", " & [First Name]

This way, you can run the report from the query and group by Full Name instead of LNAME. By grouping it my LNAME, it will default to showing the last name, then listing all first names and details like it is.

by john_wills

In your report, group by driver number. The sorting-and-grouping window can be made available by clicking the sideways beard next to the hammer-and-spanner sign in the toolbar.

by haris

Yes email the data and i will render your required query. You can also send me the layout of the required report either in word or scanned from a paper. I will develop your report and send it to you, i dont think it will take much time.

This discussion is closed to new replies.