Home Forums Microsoft Access Microsoft Access Get numberofSales per day when date and number of sales are in the same table! RE: Get numberofSales per day when date and number of sales are in the same table!

  • Hi!

    Thanks for the reply

    I tried

    SELECT Date, NumberofSales

    FROM rKam //(the valid table)

    GROUP BY Date

    That gives me an error message: "You tried to execute a query that does not include the specified expression "NumberofSales" as part of an aggregate function"

    Any tips?:-)