Results 1 to 2 of 2
  1. #1
    jquickuk is offline Novice
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    4

    Condense Mulitple Records

    Afternoon all,

    I have a problem that I hope you guys can help with.



    I recieve a stock extract each morning and could contain mulitple lines of the same item but with different stock levels.
    What I need to be able to do using a either a query of using VB is to get one line per item but with the sum of the stock levels.

    currently:

    STOREIP IPSKU IPATP Field1 Field2 Field3 Field4 .......
    0425 123456 2 xxx xxx xxx xxx .......
    0425 123456 8 xxx xxx xxx xxx .......
    0425 123456 1 xxx xxx xxx xxx .......


    Needs to be:

    STOREIP IPSKU IPATP Field1 Field2 Field3 Field4 .......
    0425 123456 11 xxx xxx xxx xxx .......

    The IPATP is the stock value and the IPSKU is the repeated line.

    I have tried using the GroupBy and Sum functions on the query builder but it doesn't let me have all the other fields. Just the IPSKU which is set to GroupBy and IPATP which is Sum.

    Any help will appriacated.

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    I think you will need to do it in a seperate query and then link that to your main query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 08-06-2009, 11:47 PM
  2. Replies: 0
    Last Post: 02-26-2009, 03:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums