said: I am having a problem with MsAccess 7 Call Report Data base(fields of - ID,date,A/c no,Customer,Report etc.) Where there is more than one call report for each customer I require to print a report, the date of which is nearest to the current computer date. This would then list the last call report for each customer. At the present time I get a listing of all the calls to customers rather than the latest. Could anyone help please. Ian Muir.