I don't want to print blank pages!!!

[marcondes]

I'm running a statement of transactions per vendor. My problem is that vendors with no transactions still printout with a blank subform. How can I filter those out?

Thanks.

 

[RickSpr]

Modify your main report's query to exclude vendors who have no transactions. For example,
SELECT VendorID, VendorName
FROM Vendors
WHERE VendorID IN
(SELECT DISTINCT VendorID FROM VendorTransactions) Rick Sprague

 

[marcondes]

Rick,

I don't know how to code, so that makes my task a little more difficult. I don't even know where to place that piece of code you wrote above.

Is there any hope for me?

Thanks

 

[RickSpr]

That's not code, it's an SQL statement. You could enter it into a query after you've switched it to SQL view. However, don't take that sample statement literally--it's meant to show that you should include an IN clause with a subquery to limit the vendor IDs.

Rick Sprague