TheBigEasy
Registered User.
- Local time
- Yesterday, 21:02
- Joined
- Dec 12, 2019
- Messages
- 19
All...
Before I wave the proverbial 'white flag', I wanted to ask the 'experts' for some guidance as I'm stumped. Here goes...
I'm in the process of creating a 'Warranty Database' for tracking customer claims. At the end of every month, a report needs published detailing all of the claims received in that month. I have created a 'Claim Entry' form which is filled out by our Tech Service Department for every claim that they receive. Once complete, the form data is captured in the table 'TblWarranty'. I should note that each claim is given a VBA derived 'Claim Number' at the time that the form is saved. The table does contain the autonumbered 'ID' field but I have this hidden as it serves no purpose to the user.
When it's time to 'run' the monthly report, the user will activate the 'Warranty Report' button on the Main Database Form. This button opens the report 'Defect Count'. The record source of this report is the query 'Monthly Report Frequency Query'. So, once the report is opened, the user is asked to input the mm/yyyy for the time frame that the report needs to capture. After the mm/yyyy has been entered, the report displays the 'Defect' along w/ the number of the specific defect occurred within the time frame.
Defect Total Defects
Defective Part (6)
Assembly Error (6)
Shipping Damage (4)
Unknown (3)
There's then a button on the report to 'Print Warranty Report'. I have the report setup so that each 'Defect' along w/ the number of 'Total Defects' print in the report's header and then the claim w/ claim details, that make up the 'Total Defects' printing out in the Detail of the report. I have the report setup so that the 'Defect' headers are reported in descending order based on the quantity of 'Total Defects'. This works flawlessly.
Of course...someone needs something more. :banghead:
Instead of reporting the 'Defects' in descending order by 'Total Defects', they'd like the ability to 'prioritize' the 'Defect' report headers. So, I need something that will list all of the 'Defects' w/ their 'Total Defects', give the user the ability to move a 'Defect' up/down the priority list and then print the report in the user set priority.
I'd welcome any ideas, advice, examples...anything!!! that will allow my brain to sleep tonight instead of working in my own personal copy of Virtual Access. Thanks!
Before I wave the proverbial 'white flag', I wanted to ask the 'experts' for some guidance as I'm stumped. Here goes...
I'm in the process of creating a 'Warranty Database' for tracking customer claims. At the end of every month, a report needs published detailing all of the claims received in that month. I have created a 'Claim Entry' form which is filled out by our Tech Service Department for every claim that they receive. Once complete, the form data is captured in the table 'TblWarranty'. I should note that each claim is given a VBA derived 'Claim Number' at the time that the form is saved. The table does contain the autonumbered 'ID' field but I have this hidden as it serves no purpose to the user.
When it's time to 'run' the monthly report, the user will activate the 'Warranty Report' button on the Main Database Form. This button opens the report 'Defect Count'. The record source of this report is the query 'Monthly Report Frequency Query'. So, once the report is opened, the user is asked to input the mm/yyyy for the time frame that the report needs to capture. After the mm/yyyy has been entered, the report displays the 'Defect' along w/ the number of the specific defect occurred within the time frame.
Defect Total Defects
Defective Part (6)
Assembly Error (6)
Shipping Damage (4)
Unknown (3)
There's then a button on the report to 'Print Warranty Report'. I have the report setup so that each 'Defect' along w/ the number of 'Total Defects' print in the report's header and then the claim w/ claim details, that make up the 'Total Defects' printing out in the Detail of the report. I have the report setup so that the 'Defect' headers are reported in descending order based on the quantity of 'Total Defects'. This works flawlessly.
Of course...someone needs something more. :banghead:
Instead of reporting the 'Defects' in descending order by 'Total Defects', they'd like the ability to 'prioritize' the 'Defect' report headers. So, I need something that will list all of the 'Defects' w/ their 'Total Defects', give the user the ability to move a 'Defect' up/down the priority list and then print the report in the user set priority.
I'd welcome any ideas, advice, examples...anything!!! that will allow my brain to sleep tonight instead of working in my own personal copy of Virtual Access. Thanks!