G
Greg
Hi,
I have a form containing the part number, part descript,
Initial OH Balance 1 - 4 for each site location. In
short four fields for each site to record the initial
balance for a single part.
There is also a form for Part Request submitted by the
site, which contains a subform for each part requested,
that includes the quntity of the order and the amount
received. This subform is associated to the parent form
by a uniques number, which is used to identify the site
ordering the part.
Another form is for Mainteance. When a part is used, a
value of 1 is entered in the part used field. This is
based on the tblMaint with a connection to the primary
equipment record identifying the site.
On the form with the part and balance information I would
like to add a field for each site indicating that a total
of say 5 each of Part Number XXXXX has been used, and a
total of say three part have been ordered. At this point
I would like to have a field that takes the Initial
Balance to subtract the used balance and then add back
the amount received through orders, which will provide
the current balance.
Question: Is there an easy way to accomplish with one
query to sum the total parts order by a single site, that
can be used in the format below, to include applying the
same concept to a part used etc... without ending up with
2 queries for each site, along with subform for each???
In the current application, there eight forms and several
hidden uunbound filed that complete the calculations, but
there not a better way to do this? Any ideas
suggestions, where to begin, how to do, etc... will be
greatly appreciated! I've tried crosstab, total queries
then creating a single form...
Example:
Form 1: PN / Desc
12 Charging Roller (Info from part table
Start Bal Site 1/Site 2/Site 3/Site 4
Start Bal 1 5 3 2
Used -1 3 2 0 (info from tbleMaint
Received +4 2 4 1 (info from partReq
Current Bal =4 4 etc... (summation)
Thanks in advance!
Greg
I have a form containing the part number, part descript,
Initial OH Balance 1 - 4 for each site location. In
short four fields for each site to record the initial
balance for a single part.
There is also a form for Part Request submitted by the
site, which contains a subform for each part requested,
that includes the quntity of the order and the amount
received. This subform is associated to the parent form
by a uniques number, which is used to identify the site
ordering the part.
Another form is for Mainteance. When a part is used, a
value of 1 is entered in the part used field. This is
based on the tblMaint with a connection to the primary
equipment record identifying the site.
On the form with the part and balance information I would
like to add a field for each site indicating that a total
of say 5 each of Part Number XXXXX has been used, and a
total of say three part have been ordered. At this point
I would like to have a field that takes the Initial
Balance to subtract the used balance and then add back
the amount received through orders, which will provide
the current balance.
Question: Is there an easy way to accomplish with one
query to sum the total parts order by a single site, that
can be used in the format below, to include applying the
same concept to a part used etc... without ending up with
2 queries for each site, along with subform for each???
In the current application, there eight forms and several
hidden uunbound filed that complete the calculations, but
there not a better way to do this? Any ideas
suggestions, where to begin, how to do, etc... will be
greatly appreciated! I've tried crosstab, total queries
then creating a single form...
Example:
Form 1: PN / Desc
12 Charging Roller (Info from part table
Start Bal Site 1/Site 2/Site 3/Site 4
Start Bal 1 5 3 2
Used -1 3 2 0 (info from tbleMaint
Received +4 2 4 1 (info from partReq
Current Bal =4 4 etc... (summation)
Thanks in advance!
Greg