View Single Post
  #1  
Old August 3rd, 2004, 07:14 PM
external usenet poster
 
Posts: n/a
Default Printing reports with no data

I have designed an equipment inventory db. I have to
conduct an inventory of our equipment and want to print
out what I have so far so I can make any changes to it and
add equipment that isn't accounted for.

I have designed a report by employee with 4 subreports
which identify the computer, monitor, printer and any
peripherals the employee has been assigned. Each
equipment type is a separate subform.

For some employees, we have no information. For others,
we have the computer and printer, but no monitor or
peripheral info.

The tables are set up so that there is one main table
(tblInventory) and 4 additional tables (tblComputer,
tblPeripheral, tblMonitor, tblPrinter) with information
specific only to that equipment type in the secondary
table. Each table has a relationship with the main table.

How can I design my report so that all 4 subreports print,
with or without data? Right now, if an employee has a
computer, but no other information in the database, only
the computer subform prints and the rest of the page is
blank.

Thanks in advance for any help!
Tina