Search results

  1. B

    Subquery whit 2 values and a max fonction

    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
  2. B

    Subquery whit 2 values and a max fonction

    This is an excel sheet whit the data
  3. B

    Subquery whit 2 values and a max fonction

    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]...
Back
Top Bottom