the issue is that in the example I copy the way that the report is supposed to work. Right now, the report looks like the example fields with the difference that I don't get the last transaction date (in red). I don't know how I can get just the last transaction as show in the example. i don't need the details of the others transaction dates, I just need to get the last date in that field for each user. Example:

 

PatronID   LastTransdate       User Name    Active    Balance

001            15-May-2006        Albert Brow      0          $3.00

002            16-Jun_2005        Maria Garcia     0          $4.00

 

 

Thanks,

 

I think you're right, we're having issue understanding each other.

The example info that is in the message is the info that is supposed to be in the report. All the info is showed in the report, but with the only issue that the 'transaction date' is not in the report. This is the issue that I'm trying to fix. There is not other data in the report. I'm using UserID, UserLast and first name, Last TransactionDate (which is not working now), Active, and account balance (I'm using three different tables in order to get all the info needs). The data is group by User Classification. I made two statement (Select Expert) to filter the data. First, the date is filter if the user is inactive (0). Second, if the user have at leasta $10 in his/her account (>=10). I have two summaries in my the report one for each user "clasification". And second, one for the grand summaries total. So as yuo can see, the report is almost working, but I'm missing part where the last transaction date is supposed to be showed in the report. This info that is not working right now. I need to add this info into it, but I don't know how to do it.

 

I hope that now it's more clear for you.

 

Thank so much.