I have an access database that is used for residential inspections. The main table is the situs information while a linked subtable is the inspection information. The subtable is linked via situs ID. My problem is that when trying to create a report that list each address and all inspection information associated with that address only one inspection will print. The inspection fields are v-ditch, slope, manuer, date, insp by, and letter sent. The record will only print in crystal if ALL feilds from the inspection table have data. There are many instances where there is only a letter sent so the v-ditch and slope feilds are left null. How can I get all inspections to print for each address.
Thanks
Derek