Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
I need to print N/A on a report when null value is returned.
Tom, The report is all one thing, no subreports. It is laid out with part of the Info Table's feilds at the top, and at the bottom. And then there are each of the Store Table's data in the center. I have done my best to give you an idea below. The info table holds all the order info...- WildTaz
- Post #6
- Forum: Microsoft: Access Reports
-
I need to print N/A on a report when null value is returned.
The way that it works is like this. There is one table that has all of the information, and 6 tables that have the PO numbers. The form uses the Info feilds which apply an AutoNumber, and the Form has SubForms for each table with the PO Numbers. When you click on one of the Yes/No feilds in...- WildTaz
- Post #4
- Forum: Microsoft: Access Reports
-
I need to print N/A on a report when null value is returned.
I am trying to make a Purchase Order generator. Access and the reports are fine and working great if I am selecting to make a PO# for every store. But when I try to only make one or two PO#s and leave the rest blank, I get a blank report. My tables are set up as such: * poInfo - has all of...- WildTaz
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
