Hi all! I've worked with Access frequently in the past (Access 97) and now need to work on a project that I think Access 2007 will be able to tackle (at least I hope so!). I have imported two tables similar to the following:

Car Info Table
---------------------


Car ID (PK)
Make
Model
Color


Service Record Table
---------------------------
Service ID (PK)
Car ID (FK)
Service Type (Oil change, tune-up, body work, etc.)
Date


Each car (record) in the car info table corresponds with multiple service records entries in the service table. What I need to do is format the data for export as HTML where each HTML page contains the car info at the top and the service record details listed below. Any ideas on how I should approach this? I tried creating a test report linked only to the service record table and grouped by the service ID and sorted on service date. However, this is incomplete as I need to include the car details at the top and the export puts info for one car on multiple HTML pages. Any suggestions are greatly appreciated.

Thanks,
Al