Eliminating Repetitive Data in a query/report

[Ranger7913]

I am somewhat new to developing functional Access databases. I have created a database to track employee training, records and inspections in a trucking environment. I have a master table with just the employee's identifying info. I have a table for inspections which has fields capturing the major information from an inspection, i.e, the date, county issued, unit number, etc. This table is linked to the employee table by their file number. I created a third table listing only the violations. In this table, I have fields to capture the statute, violations noted, whether or not a citation was issued. I have linked this table by the employee file number and date of issue. I created a form/subform to enter the data. My ultimate goal is to produce a report that will list the driver, the inspection info and violations in one block. Some of these employees may have multiple inspections over a given time. Could anyone advise how to create a query and report that will accomplish this without repeating the identifying information or other unrelated information over and over. Thanks for any help.

[June7]

Options:

1. subreports

2. report Grouping & Sorting feature

[Ranger7913]

Thanks June7. That worked perfectly. I created this database and have split it so other users can also update the files. I have also made an accde file that is working well so far. The accde file allows users to create their own query but for some reason they can not create their own reports. I thought I had read somewhere an accde file would allow individual queries and reports to be created on the user's copy. Is there something I need to do to make that happen or is only queries that are allowed?

[June7]

Sorry, never used accde and never set up a db where users could design their own reports. Sounds very complicated. There is so much formatting involved in creating a report object. My advice is to develop a set of standardized reports and users select filter criteria on form.