Recent content by Blacksun

Thanks you its work For the name i know but its was not me who design the DB and the name are the one from the excel sheet they use. I have made some change but i cannot change everything for now

This is an excel sheet whit the data

Hello I have 2 query: Maxdate: SELECT [table Receive].[client code], Max([table Receive].[Date]) AS [MaxOfDate] FROM [List] INNER JOIN [table Receive] ON [List].[Number] = [table Receive].[Client Code] GROUP BY [table Receive].[client code] and the second SELECT maxdate.[Client Code]...