-
February 13th, 2017, 06:56 PM
#1
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
-
February 14th, 2017, 10:57 AM
#2
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
-
February 17th, 2017, 11:14 PM
#3
Re: Query group before and has numbered in access 2003 ?
-
February 18th, 2017, 08:58 AM
#4
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|