G
Guest
I have a quote program designed in Access 2000. When generating the quote report the quote is displayed using one line per item quoted.
My problem is as follows. If the quote is a tally item (Ordering 2000 feet of lumber but getting 80 @ 20 ft etc) I want to display the line item and the tally item breakdown below it. I can do this but I only want it displayed if there is a value in the field. Currently for null fields the spacing still shows up on the report. Is there a way to surpress the field if it is null and not have that extra spacing in the report? Below is an example of what I want:
Crystal Reports provides a very easy way of doing this by adding additonal detailed sections and surpressing the whole section if meeting a specified criteria.
Part Number Item
12541 BCI2200
20 @ 7ft, 50 @ 5 ft, 56 @ 9 ft (Tally Item)
21455 XXXX
2345 BBBBB
4957 CCCC
56 @ 9 ft (Tally Item)
Thanks
My problem is as follows. If the quote is a tally item (Ordering 2000 feet of lumber but getting 80 @ 20 ft etc) I want to display the line item and the tally item breakdown below it. I can do this but I only want it displayed if there is a value in the field. Currently for null fields the spacing still shows up on the report. Is there a way to surpress the field if it is null and not have that extra spacing in the report? Below is an example of what I want:
Crystal Reports provides a very easy way of doing this by adding additonal detailed sections and surpressing the whole section if meeting a specified criteria.
Part Number Item
12541 BCI2200
20 @ 7ft, 50 @ 5 ft, 56 @ 9 ft (Tally Item)
21455 XXXX
2345 BBBBB
4957 CCCC
56 @ 9 ft (Tally Item)
Thanks