CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2007
    Posts
    405

    Query group before and has numbered in access 2003 ?

    Suppose a data table can access 2003 such as fields execel file attachments, I want to query the warehouse group by name, bar code, goods, inventory, and then type the serial number, the results of its attachments write queries like? Attachments: http://www.mediafire.com/file/lv73f1usj5yqdk2/STTen.xls

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Query group before and has numbered in access 2003 ?

    Please, attach the files to your post rather than posting a link to some unknown site.
    Victor Nijegorodov

  3. #3
    Join Date
    Sep 2007
    Posts
    405

    Re: Query group before and has numbered in access 2003 ?

    You here: STTen.rar

  4. #4
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Query group before and has numbered in access 2003 ?

    Something like
    Code:
    SELECT Table1.BARCODE, Table1.GOODS, Table1.WAREHOUSE, Sum(Table1.NUMBERIMPORT) AS TON
    FROM Table1
    GROUP BY Table1.BARCODE, Table1.GOODS, Table1.WAREHOUSE;
    ?
    Victor Nijegorodov

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured