I have multiple tables, ( One client table ) ANother table contains vehicles owned. They have three vehicles. I have a purchased date in this table ( vehicle table ). I only want the "newest" or "latest" or the last one purchased to appear. Not matter how I write it I get multiple reports, even if I use a "command" table. ( I have tried using "maximum" statements with no luck whatsover. When I try to use it in the report selection formula I get an error and tells me "Needs to be evaluated Later" I only want the vehicle name I only need the purchase date to "select" the correct vehicle. ( By the way the client table is a stored procedure with over fifty fields. The link is by Client ID.) Please help

I even tried this statement directly in the SQL database still get three entries. In SQL you can only use the Max() statement as a field by itself. ( I cannot ask to link by client. )

 

P.S. I tried a "sub-report" the same vehicle appears ( the correct one ).However I still get three pages of reports... One I guess for each vehicle.