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!

  • February 17, 2012 at 8:57 am

    #1448586

    look up "GROUP BY"

    this should help

    EDIT:....just seen that this is Access

    in query design use the "Totals" option...this will utilize "Group By"

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day