Problem with duplicates in Access 2003

[Kellee]

I have looked through all the posts I can find about duplicates and can't
seem to find the answer to my problem so any guidance is appreciated!

I have created a report which lists insurance information for our vendors.
The report is based on a query and grouped by the location of the projects
that they work on. One location can have multiple vendors and vendors can
work in multiple loactions.

My tables are as follows:
tLocations
LocationID*
ProjectLocation

tProjects
ProjectID*
LocationID (fk)
....

tInvoices
VendorID*
InvoiceNo*
Project ID (fk)
....

tVendors
VendorID*
Contact
Phone
Fax
GLExp
WCExp
....

My report is based on a query (qInsurance) that has the fields
ProjectLocation, VendorID, Contact, Phone, Fax, GLExp, WCExp, etc. I have
sorted the report so that it groups by the ProjectLocation. The problem is
that since the VendorID and ProjectLocation are joined only through their
invoices, there are many listings for each vendor within each location. I
have tried the HideDuplicates properties, but since many expiration dates are
the same, this causes problems. I have also tried putting the details in the
project header section but it then only lists the first vendor for each
location. In the end, I want the report to list each vendor once in each
applicable location, as follows:

Location1
Vendor Contact Phone Fax GLExp WCExp (as column labels)
Vendor1 Contact1 Phone1 Fax1 [date] [date]
Vendor2 Contact2 Phone2 Fax2 [date] [date]

Location2
Vendor Contact Phone Fax GLExp WCExp (as column labels)
Vendor2 Contact2 Phone2 Fax2 [date] [date]
Vendor5 Contact5 Phone5 Fax5 [date] [date]

Location3
Vendor Contact Phone Fax GLExp WCExp (as column labels)
Vendor1 Contact1 Phone1 Fax1 [date] [date]
Vendor5 Contact5 Phone5 Fax5 [date] [date]

Thanks so much for taking the time to read my post!