Automate

 View Only

  • 1.  Is there a way to only return the max value as in SQL

    Posted 04-08-2021 19:51
    I'm looking for a way to return only the last date or sales order for a list of customers.   Is there a way to do this in the query so I don't have to return every record for every customer, then perform the search after in Excel?   It would be a lot of records.

    ------------------------------
    Corwyn Coleman | Data & Analytics
    Spartan Controls Ltd | 7804408331
    ------------------------------


  • 2.  RE: Is there a way to only return the max value as in SQL

    Employee
    Posted 04-12-2021 12:40
    Hi Corwyn

    Sorry, no, not in Query.  Can you use a date range instead?   If not, I would output all of the data and then create a pivot table and use a max function for the date.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message