Selection problem

[savok]

I have an access table that I use in a report, it has a PayID and PayAmount.

I pass PayID from VB to crystal and based on the payID make the selection
{Payments.Pay_ID} = {?PayID}

But i also need to display on the same form a total sum of all PayAmount. How would I select all payments? if I alreayd put that formula in the selection?

thanks

 

[IdoMillet]

You must remove the record selection, since it obviously removes the records you need for the unrestricted total.

You can then create the total for the selected PayID using various options:

One option is to use a Running Total that gets evaluated based on a Formula (like your record selection formula).

Another option is to create a conditional formula
IF ({Payments.Pay_ID} = {?PayID}, PayAmount, 0)
and total it.

Another option is to conditionally suppress all other records...

Cheers,
- Ido