Hi all,

I sure this will be a simple solution but I just can't figure-out what how to do it.

I have two tables;

Table A

Client ID

Client Name

Complain

Solution

Table B

Client ID

Invoice No

Invoice Amount

Invoice Amount Total (Summary Field)

I also have a layout that shows field from from Table A and Table B.

I need to show the "Invoice Amount Total" for a given Found Set without sorting on a Header or Sub-summary part but in Browse Mode.

Any help is GREATLY appreciated

Thanks

RudyM

Edited March 28, 201015 yr by Guest

Put Invoice Amount Total (Summary Field) on the layout.

Hey Bruce thanks for the post.

If I place the "Summary Field" on the Body or the Header- It will only show the total for a single record.

If I create a "Sub-summary Part" below and above and it also only shows total for record.

Thanks

Rudy

That's definitely not true. A summary field shows the data for the found set. That's exactly what it's used for. I suggest you post a copy of your file; or a clone; or a simplified version so that we'll have something to look at.

Regarding:

"I also have a layout that shows field from from Table A and Table B."

This statement needs clarification - what is the table occurrence that this layout is based on?

Edited March 28, 201015 yr by Guest