Designing a Query or Text Box

[Guest]

I would like to have to total payments made by my clients displayed in the
invoice. I want only that client's payments to display. Also, I would like
to design a query or text box to subtract total payments from the total
invoice amount to arrive at the net amount due. How do I do this?

I am trying to modify the time and billing template on the MS website to
suit my needs.

Thanks.

 

[Duane Hookom]

You should be able to use a subreport to display the total payments. You can
then use the total in calculations on the main report.

 

[Guest]

I did a query that sums the payments by client number. How do I get the box
to display only the payments for the client whose invoice is displayed? When
I import the query I get all the payments for all the clients.

Thanks.

 

[Duane Hookom]

Use the Link Master/Child properties of the subreport control to filter the
subreport records to a value on the main report.

 

[Guest]

How do I do this? Thanks.

Use the Link Master/Child properties of the subreport control to filter the
subreport records to a value on the main report.

 

[Duane Hookom]

I'm not sure how to be much more explicit. Select your subreport control and
display the properties. Find the Link Master/Child properties and set them
to the field(s) that identify the relationship.