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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.