|
 |
access thread: Access97 printing problems
Message #1 by stan@4... on Wed, 29 May 2002 18:35:46
|
|
I?m trying to produce a report using Access 97. I am grouping my data by
customer. The detail consists of invoice and payment transactions for each
of the customers. Since some customers are paid in full, the group footer
balance, under the "Balance" field is zero. "Balance" is a calculated
field.
I want to suppress all the zero balance group footer balances along with
the detail information associated with those records. I am only interested
in printing the detail records and the group footer balances of those
records that still have a balance other than zero.
In the following example I do not need any of the AAA customer data since
the balance is zero
Customer Date Invoice Payment Balance
AAA 01-May-02 1,500.00 1,500.00
AAA 05-May-02 500.00 500.00
AAA 15-May-02 2,000.00 (2,000.00)
Totals: 2,000.00 2,000.00 0.00
BBB 01-May-02 1,500.00 1,500.00
BBB 05-May-02 500.00 500.00
BBB 15-May-02 1,000.00 (1,000.00)
Totals: 2,000.00 1,000.00 1,000.00
Your help will be eternally appreciated if anyone can offer me a solution
to this problem.
Thanks,
Stan
Message #2 by "Leo Scott" <leoscott@c...> on Wed, 29 May 2002 12:02:18 -0700
|
|
Why not base the report on a query that filters out any customers that have
a 0 balance.
|-----Original Message-----
|From: stan@4... [mailto:stan@4...]
|Sent: Wednesday, May 29, 2002 6:36 PM
|To: Access
|Subject: [access] Access97 printing problems
|
|
|I?m trying to produce a report using Access 97. I am grouping my data by
|customer. The detail consists of invoice and payment transactions for each
|of the customers. Since some customers are paid in full, the group footer
|balance, under the "Balance" field is zero. "Balance" is a calculated
|field.
|
|I want to suppress all the zero balance group footer balances along with
|the detail information associated with those records. I am only interested
|in printing the detail records and the group footer balances of those
|records that still have a balance other than zero.
|
|In the following example I do not need any of the AAA customer data since
|the balance is zero
|
| Customer Date Invoice Payment Balance
| AAA 01-May-02 1,500.00 1,500.00
| AAA 05-May-02 500.00 500.00
| AAA 15-May-02 2,000.00 (2,000.00)
| Totals: 2,000.00 2,000.00 0.00
|
| BBB 01-May-02 1,500.00 1,500.00
| BBB 05-May-02 500.00 500.00
| BBB 15-May-02 1,000.00 (1,000.00)
| Totals: 2,000.00 1,000.00 1,000.00
|
|Your help will be eternally appreciated if anyone can offer me a solution
|to this problem.
|
| Thanks,
| Stan
|
Message #3 by "Wesley Kendrick" <wez.k@n...> on Thu, 30 May 2002 06:34:57 +0100
|
|
Hi Stan, try putting the following code into the report footer 'on format'
property:
If [Balance Field] = 0 Then [Balance Field].Visible = False
Hope this helps,
Regards, Wesley Kendrick
---- Original Message -----
From: <stan@4...>
To: "Access" <access@p...>
Sent: Wednesday, May 29, 2002 6:35 PM
Subject: [access] Access97 printing problems
> I'm trying to produce a report using Access 97. I am grouping my data by
> customer. The detail consists of invoice and payment transactions for each
> of the customers. Since some customers are paid in full, the group footer
> balance, under the "Balance" field is zero. "Balance" is a calculated
> field.
>
> I want to suppress all the zero balance group footer balances along with
> the detail information associated with those records. I am only interested
> in printing the detail records and the group footer balances of those
> records that still have a balance other than zero.
>
> In the following example I do not need any of the AAA customer data since
> the balance is zero
>
> Customer Date Invoice Payment Balance
> AAA 01-May-02 1,500.00 1,500.00
> AAA 05-May-02 500.00 500.00
> AAA 15-May-02 2,000.00 (2,000.00)
> Totals: 2,000.00 2,000.00 0.00
>
> BBB 01-May-02 1,500.00 1,500.00
> BBB 05-May-02 500.00 500.00
> BBB 15-May-02 1,000.00 (1,000.00)
> Totals: 2,000.00 1,000.00 1,000.00
>
> Your help will be eternally appreciated if anyone can offer me a solution
> to this problem.
>
> Thanks,
> Stan
>
>
|
|
|
View Cart
