Base form/report on multiple queries?

[BPBP]

I am making a Form/or report that shows some stats about jobs assigned and jobs attended, and manhours incurred, response time, turn around time, etc... by a couple of engineers in their daily work.

For all these required stats i have an individual query for each. However, I want to make a form or report to show all these stats together. Is this even possible? Or is there a simpler/better way to do this? To compile all the statistic, i would probly need to make 20-30 queries.


(note: all the data comes from 1 single table, although each statistic uses different fields and different criteria)

For eg.
Part 1 - for number of jobs attended by Engineers, i have a query to count the number of rows of manhours fields clocked by the Engineer(each engineer have 1 manhour field) with criteria where it is not = 0 and with also date range criteria. I have 5 engineers (Hence 5 queries for just this stat on jobs attended and 5 times to key in the date range... ...). Is there an easier way?


Part 2 - some other stats based on other queries (calculated which i haven got it to work yet... will check on this when i solve part 1 first)

Many thanks.

 

[BPBP]

Yes i understood normalisation. It was applied in my database. Perhaps the way the relationship was conceived in the first place wasnt good enough. but its too late to rethink and change now, too many forms/queries/vba/macros all over the place.

So i figured the conclusion would be, the answer for my question is this is not possible?

Even if the engineer fields were in a seperate table, i'll still need to query it out and there are other fields such as job start/end dates where i get the difference to get the number of days jobs completed, count of all the numbers of days completed to see average/statistics and many more other stuff which i only know how to pull out using seperate need queries. And all these statistics needs to be in 1 form/report....

I thinking of just for all these, to use only textboxes with some functions like Dsum, Dcount etc to pull the data out to manipulate... but am worried these functions may have some limitations or functional limitations in the textbox control source entries capable of handling.