Hi
I have a table with these fields in it , “job number”; “date in”;”required date”; “completion date”. I need to make a report to show, total Jobs in, jobs finished on time, jobs finished late and jobs outstanding.
So I’ve got 4 separate queries
· qryJobsIn
· qryJobsOnTime
· qryJobsLate
· qryJobsOutstanding
each give me the total for each requirement but I can’t get these four queries to display on a report, 1 will work ok as this is the main record source for the form but if I add a text field and try to make an expression in the control source to one of the other queries, it just asks me for a parameter to enter instead of running the query.
At the moment I’m stumped I have four quires that give the results I need but I can’t get them to display on a report together.
Any suggestions would be helpful.
Thanks
Not sure if this is more a report question than a query one?
I have a table with these fields in it , “job number”; “date in”;”required date”; “completion date”. I need to make a report to show, total Jobs in, jobs finished on time, jobs finished late and jobs outstanding.
So I’ve got 4 separate queries
· qryJobsIn
· qryJobsOnTime
· qryJobsLate
· qryJobsOutstanding
each give me the total for each requirement but I can’t get these four queries to display on a report, 1 will work ok as this is the main record source for the form but if I add a text field and try to make an expression in the control source to one of the other queries, it just asks me for a parameter to enter instead of running the query.
At the moment I’m stumped I have four quires that give the results I need but I can’t get them to display on a report together.
Any suggestions would be helpful.
Thanks
Not sure if this is more a report question than a query one?