T
Tom N via AccessMonster.com
Hello Ya'll
I am trying to put together a Inventory Database, But my one Big problems is
because there is multiply locaations in the warehouse the part number get
listed multipy time on my import Excel Spreed sheet.
For example: (There are more fields but this is the bottom Line)
part Number Qty Location
3125-5546-00 5 1
3125-5546-00 6 2
I want the Query to Scan for mult. of the same part number and output this
back in to the Query.
3125-5546-00 11 (then remove the 2nd line that is
not needed now)
Does anyone has some helpful hints for my problem.
I am trying to put together a Inventory Database, But my one Big problems is
because there is multiply locaations in the warehouse the part number get
listed multipy time on my import Excel Spreed sheet.
For example: (There are more fields but this is the bottom Line)
part Number Qty Location
3125-5546-00 5 1
3125-5546-00 6 2
I want the Query to Scan for mult. of the same part number and output this
back in to the Query.
3125-5546-00 11 (then remove the 2nd line that is
not needed now)
Does anyone has some helpful hints for my problem.