Results 1 to 2 of 2

Thread: Adding values

  1. #1
    Join Date
    Nov 2003
    Location
    Queensland
    Posts
    17

    Unanswered: Adding values

    Hi all just a quick question. I'm trying to create a query to calculate the total quantity sold for each item. For example say I sell 5 of the same books over a period of a month, is there a way the I can get a query to count the quantity sold and just display it as one record in the query instead of listing every sale. The fields in my stock table are Date, ID, Item and Quantity. Any help would be appreciated thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Quote Originally Posted by Peter Masters
    Hi all just a quick question. I'm trying to create a query to calculate the total quantity sold for each item. For example say I sell 5 of the same books over a period of a month, is there a way the I can get a query to count the quantity sold and just display it as one record in the query instead of listing every sale. The fields in my stock table are Date, ID, Item and Quantity. Any help would be appreciated thanks.
    SELECT Count(yourTable.id) AS [Number of Items]
    FROM yourTable;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •