Total Novice Access user. While I have used access for years I have only ever needed to use the basic built in features for organizing and tracking information and making basic reports. I am a purchasing/CS guy and have zero training or experience in programming/SQL/Macros, etc.
I work for a repair shop that takes in customer units, tears them down, then quotes to repair as needed.
The current dB has 2 tables (linked via relationship on job# field)
The management now wants a report to show yes/no of jobs by customer so we can see the ratio of how many they approve versus decline.
I have created a report (and supporting crosstab query) that will tell us how many "Go" and how many "No-job" for each customer. The querry only has the Job table in it.
Now I need to be able to add up the $ for only the "No-job" jobs and show it so they can see the lost revenue for just those. They also want to see how much total labor the shop has put into the "No-jobs" for that customer. I have tried a number of times but I just cannot get it to work. I also find if I add the hours table to the crosstab query, the go/nogo job count stops working.
Can anyone help? What do I need to maybe upload so you can see what I have so far?
I work for a repair shop that takes in customer units, tears them down, then quotes to repair as needed.
The current dB has 2 tables (linked via relationship on job# field)
- JOBS-(One entry per job #)-All basic job information, numerous dates, notes, cost, hours estimations, etc.
- HOURS-(Many entries per job#)-job#, date for work, techinician, hrs per task
The management now wants a report to show yes/no of jobs by customer so we can see the ratio of how many they approve versus decline.
I have created a report (and supporting crosstab query) that will tell us how many "Go" and how many "No-job" for each customer. The querry only has the Job table in it.
Now I need to be able to add up the $ for only the "No-job" jobs and show it so they can see the lost revenue for just those. They also want to see how much total labor the shop has put into the "No-jobs" for that customer. I have tried a number of times but I just cannot get it to work. I also find if I add the hours table to the crosstab query, the go/nogo job count stops working.
Can anyone help? What do I need to maybe upload so you can see what I have so far?