All Part Transactions on one form????

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

Russ via AccessMonster.com

Help,
Need to have a form that shows all part transactions;
Example
Date Part Number Purchased Sold Used
1/1/02 1234 0 3 0
1/2/02 1234 3 0 0
1/3/02 1234 0 0 3
tables;
items Purchased...
tblAcq
tblAcqDetails
items sold / shipped...
tblOrders
tblOrderDetails
items Used...
tblWorkOrders
tblWorkOrderDetails
Have not been able to figure this one out.
Any help would be great.
 
Help,
Need to have a form that shows all part transactions;
Example
Date Part Number Purchased Sold Used
1/1/02 1234 0 3 0
1/2/02 1234 3 0 0
1/3/02 1234 0 0 3
tables;
items Purchased...
tblAcq
tblAcqDetails
items sold / shipped...
tblOrders
tblOrderDetails
items Used...
tblWorkOrders
tblWorkOrderDetails
Have not been able to figure this one out.
Any help would be great.
Click to expand...

Could you explain what you want figured out? You post a portion of a
datasheet, and some tablenames. It's not at all clear what you are
asking!

John W. Vinson[MVP]
 
John,
What I need is a summary form and or datasheet of all part transactions, this
would include part acquisition via purchase order this information is stored
in the following tables (tblAcq & tblAcqDetails) consumption via maintenance
this information is stored in the following tables (tblWorkOrders &
tblWorkOrderDetails) and parts being shipped out this information is stored
in the following tables (tblOrders & tblOrderDetails). Note: this is a
summary form showing the trail of transactions the will affect the part
inventory.

Example
Date Part# Purchased Sold Used
1/1/02 1234 0 3 0 (on 1/1/02, no parts
purchased (acquisitioned) 3 parts were sold (shipped out), no parts consumed
(maintenance)
1/2/02 1234 3 0 0 (on 1/2/02, 3 parts were
purchased (acquisitioned) no parts were sold (shipped out), no parts consumed
(maintenance)
1/3/02 1234 0 0 3 (on 1/3/02, no parts
purchased (acquisitioned) no parts were sold (shipped out), 3 parts were
parts consumed (maintenance)

Hope this helps...



John said:
Help,
Need to have a form that shows all part transactions;
Click to expand...
[quoted text clipped - 15 lines]
Have not been able to figure this one out.
Any help would be great.
Click to expand...

Could you explain what you want figured out? You post a portion of a
datasheet, and some tablenames. It's not at all clear what you are
asking!

John W. Vinson[MVP]
Click to expand...
 
Any ideas????
John,
What I need is a summary form and or datasheet of all part transactions, this
would include part acquisition via purchase order this information is stored
in the following tables (tblAcq & tblAcqDetails) consumption via maintenance
this information is stored in the following tables (tblWorkOrders &
tblWorkOrderDetails) and parts being shipped out this information is stored
in the following tables (tblOrders & tblOrderDetails). Note: this is a
summary form showing the trail of transactions the will affect the part
inventory.

Example
Date Part# Purchased Sold Used
1/1/02 1234 0 3 0 (on 1/1/02, no parts
purchased (acquisitioned) 3 parts were sold (shipped out), no parts consumed
(maintenance)
1/2/02 1234 3 0 0 (on 1/2/02, 3 parts were
purchased (acquisitioned) no parts were sold (shipped out), no parts consumed
(maintenance)
1/3/02 1234 0 0 3 (on 1/3/02, no parts
purchased (acquisitioned) no parts were sold (shipped out), 3 parts were
parts consumed (maintenance)

Hope this helps...
[quoted text clipped - 7 lines]
John W. Vinson[MVP]
Click to expand...
Click to expand...
 
John, I am still looking for any suggestions.
Thanks
Russ

John said:
Help,
Need to have a form that shows all part transactions;
Click to expand...
[quoted text clipped - 15 lines]
Have not been able to figure this one out.
Any help would be great.
Click to expand...

Could you explain what you want figured out? You post a portion of a
datasheet, and some tablenames. It's not at all clear what you are
asking!

John W. Vinson[MVP]
Click to expand...
 
Back
Top