How to find in a summary ?

[Bobbby]

Hi,

I have a table of Client Sales, with Client ID, Product ID, Amount Paid, Sale Date ... and a summary of Amount Paid.

If I do a find on

Client ID = "1234" and

Sale date = "2007"

I can see a group of records and the summary of Amount Paid shows the year's total for that specific Client ID.

So far so good.

But I would like to search directly from Find mode for

Sales Date = "2007" and

Summary Total of Amount Paid > "500"

so as to find all the clients who have paid more than 500 over all sales in 2007.

Is this possible ?

TIA

Bobbby

[comment]

You cannot search for a summary value, because it doesn't exist. It is calculated AFTER the found set is established.

You can search in the Client's table (after defining a new relationship to the Sales table, filtered by year) in a calculation field = Sum ( SalesInYear::AmountPaid ).