G
Guest
I have this table:
ITEMS
ITEM ASSY PAINT SHIP
Chair A001 P001 S001
Table A002 P002 S002
Bed A003 P003 S003
Then I have a form and I capture the fallowing data
DEPARTMENT
DATE
ITEM
UNITS
I need one query that give me this data.
QUERY 1
ITEM UNITS DEPT OPER
Chair 2 ASSY A001
Chair 3 PAINT P001
Bed 4 ASSY A003
Bed 3 PAINT P003
Table 2 SHIP S002
Table 1 ASSY A002
So this means that each item may have a different
operation base on the department.
and there's where I need help.
I will preciated any help the more detail the better since I'm just start
using access.
Thanks.
ITEMS
ITEM ASSY PAINT SHIP
Chair A001 P001 S001
Table A002 P002 S002
Bed A003 P003 S003
Then I have a form and I capture the fallowing data
DEPARTMENT
DATE
ITEM
UNITS
I need one query that give me this data.
QUERY 1
ITEM UNITS DEPT OPER
Chair 2 ASSY A001
Chair 3 PAINT P001
Bed 4 ASSY A003
Bed 3 PAINT P003
Table 2 SHIP S002
Table 1 ASSY A002
So this means that each item may have a different
operation base on the department.
and there's where I need help.
I will preciated any help the more detail the better since I'm just start
using access.
Thanks.