#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0

    Simple Access Question, Need Help.


    I'm designing a database for an online ebay store and I've come across a problem. I have a query that lists how much inventory I have on hand, however I don't know how to add up separate records of the same item. I have provided a picture of my query to help explain my problem, http://i.imgur.com/P3P0N.jpg . From the image you can see that the first 2 records are the same item purchased on different dates. How do I add up those 2 items into one record for easy inventory keeping?
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,620
    Rep Power
    650
    That would be an aggregate (GROUP BY) query. Query in design view, click the Totals button. Will have to remove the ID and date fields from the query and set GROUP BY under ItemName field and Sum under Quantity.

    Or build a report using Grouping & Sorting with aggregate calcs functionality. This will allow display of detail records and summary data.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm

Similar Threads

  1. Simple Question
    By ProEdge in forum .NET Development
    Replies: 3
    Last Post: September 29th, 2004, 09:21 AM
  2. Simple question about DB access
    By Phearox in forum ASP Development
    Replies: 2
    Last Post: August 15th, 2004, 05:28 PM
  3. Simple Access Database Question/Problem
    By lycaeum in forum Microsoft Access Help
    Replies: 4
    Last Post: August 6th, 2004, 01:37 PM
  4. Simple SQL problem from a simple Access user
    By Mir72 in forum Microsoft Access Help
    Replies: 2
    Last Post: May 26th, 2004, 08:53 AM
  5. Simple Question from a simple moron
    By mrossnagel in forum ASP Development
    Replies: 2
    Last Post: March 16th, 2004, 01:29 PM

IMN logo majestic logo threadwatch logo seochat tools logo