Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: Simple Access Question, Need Help.

Results 1 to 2 of 2
Share This Thread →
  1. #1
    Shantmov is offline Registered User
    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
    June7's Avatar
    June7 is offline Moderator
    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    649
    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

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates