I am sure this has been answered somewhere but my searching has not turned it up.
What I am trying to do:
I have a table called tbl_auditdata that has many fields. Data from several different input forms are first created by one form, updated by a second form and finally completely finished updating by a third form (three different groups of people manipulating records). The fields in tbl_auditdata I am concerned with are:
PartNumber (there is another table listing all part numbers called tbl_parts and is a dropdown field in the first input form used to create the record)
TotalReceived
TotalVisInspected
TotalVisBad
TotalVisGood
TotalFunctTested
TotalFunctBad
TotalFunctGood
I am trying to make a form that has one thing on it... The Part Number dropdown.
With this dropdown I want to choose a single part number to generate a report that: (*note: there are many records related to each different part number).
1) Displays the part number selected from the form.
2) Totals all quantities of that selected part number received (in tbl_auditdata the field is named TotalReceived).
3) Totals all quantities of that selected part number visually inspected (in tbl_auditdata the field is named TotalVisInspected).
4) Totals all quantities of that selected part number visually bad (in tbl_auditdata the field is named TotalVisBad).
5) Totals all quantities of that selected part number visually good (in tbl_auditdata the field is named TotalVisgood).
6) Totals all quantities of that selected part number functionally tested (in tbl_auditdata the field is named TotalFunctTested).
7) Totals all quantities of that selected part number functionally bad (in tbl_auditdata the field is named TotalFunctBad).
8) Totals all quantities of that selected part number functionally good (in tbl_auditdata the field is named TotalFunctGood).
I am trying to determine some statistics on this data in an easy to use form for my bosses.
Here is a scenario. In tbl_auditdata I can filter by a single part number. I have the row at the bottom of the TotalReceived field in the datasheet that totals the row and I can see how many have been received. I have the same below the other fields I need to see totals for as well.
This shows me some of the information I would like to have show up on a report when someone chooses a part number from the dropdown on the form.
Is there anyone that can see their way clear to help me with this?
What I am trying to do:
I have a table called tbl_auditdata that has many fields. Data from several different input forms are first created by one form, updated by a second form and finally completely finished updating by a third form (three different groups of people manipulating records). The fields in tbl_auditdata I am concerned with are:
PartNumber (there is another table listing all part numbers called tbl_parts and is a dropdown field in the first input form used to create the record)
TotalReceived
TotalVisInspected
TotalVisBad
TotalVisGood
TotalFunctTested
TotalFunctBad
TotalFunctGood
I am trying to make a form that has one thing on it... The Part Number dropdown.
With this dropdown I want to choose a single part number to generate a report that: (*note: there are many records related to each different part number).
1) Displays the part number selected from the form.
2) Totals all quantities of that selected part number received (in tbl_auditdata the field is named TotalReceived).
3) Totals all quantities of that selected part number visually inspected (in tbl_auditdata the field is named TotalVisInspected).
4) Totals all quantities of that selected part number visually bad (in tbl_auditdata the field is named TotalVisBad).
5) Totals all quantities of that selected part number visually good (in tbl_auditdata the field is named TotalVisgood).
6) Totals all quantities of that selected part number functionally tested (in tbl_auditdata the field is named TotalFunctTested).
7) Totals all quantities of that selected part number functionally bad (in tbl_auditdata the field is named TotalFunctBad).
8) Totals all quantities of that selected part number functionally good (in tbl_auditdata the field is named TotalFunctGood).
I am trying to determine some statistics on this data in an easy to use form for my bosses.
Here is a scenario. In tbl_auditdata I can filter by a single part number. I have the row at the bottom of the TotalReceived field in the datasheet that totals the row and I can see how many have been received. I have the same below the other fields I need to see totals for as well.
This shows me some of the information I would like to have show up on a report when someone chooses a part number from the dropdown on the form.
Is there anyone that can see their way clear to help me with this?
Last edited: