AS400 Query Question
Posted on 2010-08-26
This is a general question…. I’m posting it because of the tight timeline.
I have a repair order master - the only field I need off this file is location. However, think of it as the header record. Then I have three detail files labor, parts, and other. Each contains detail costing information. A repair order may have entries on each or only one of the detail files. Each file is keyed by the repair order number and service date.
I want to create a report which combines all work from the 3 detail files groups by vehicle number and service date. Providing total repair costs by vehicle subtotaled by service date.
Does this lend itself to query? I would normally right a sql to populate one combined file with selected information from all the detail files and then feed it to a print program or query format…… however the user wants this in query.
Any input is appreciated….. Thanks