Printing Invoices

[BB]

I am trying to print invoice reports between
certain dates and only for accounts that have charges. The report has account info (from the Account table) at the beginning of each account group, then several subreports each with a different type of charge, and at the end of the account group is the total charge.
I believe I am printing the correct dates. I have created a custom dialog box to allow the user to specify the dates and I used "Between ...." in the date of each subreport.
The problem is I still get accounts that have no charges. I have tried using "Is Not Null", but maybe I'm not using it in the correct place??
Can anyone give me suggestions from what I have tried to explain?

Thanks, BB

 

[Rich]

Not IsNull is the prefered syntax in vba, but I would suggest your sub reports and main reports are based on queries and linked to the main report by some key field. The main report would be based on a parameter query. The syntax for criteria in the grid is Not Is Null and without any quotes.
HTH

 

[BB]

Yes, the subreports are based on queries. They include such things as date of service, some sort of ID number, description, unit price, quantity, price*quantity. One of the subreport queries is a little more complicated. This may be my problem? It includes several subqueries, because it again includes several types of charges. I had to deal with the fact that there may be no charges here.
No, the main report is not based on a query. It includes account info from the Account table. The subreports are linked to the main form by the Account Number.
I did not use a parameter query. I used what I think is called query by form, using a custom dialog box, similar to what is used in the Northwind "Sales by Year Dialog".