brbarto
Technical User
- Sep 6, 2001
- 34
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?
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.
The subreports are linked to the main form by the Account Number.
Thanks, brbarto
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?
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.
The subreports are linked to the main form by the Account Number.
Thanks, brbarto
