A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing reports with no data



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing colour in reports Pat Hartman Setting Up & Running Reports 0 July 8th, 2004 05:39 PM
How to create graphs in a monthly report where the base data can change John Clarke Charts and Charting 3 June 25th, 2004 02:22 AM
Data Labels on Charts in Reports Frank Setting Up & Running Reports 0 June 3rd, 2004 03:00 AM
Printing subform data in Access XP Raj K Using Forms 3 May 31st, 2004 02:24 AM
Collapsing rows with no data for printing John Sullivan Worksheet Functions 2 April 17th, 2004 05:42 PM


All times are GMT +1. The time now is 05:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.