I am trying to display information in Access on a form that takes
information from many different queries and puts them together on a
spreadsheet or chart.
Some specific info: The information I am displaying consists of a work
order schedule(for the current date), work orders completed , work
orders not completed, a past due schedule, past due completed, and past
due not completed. These are grouped by workcenters. Therefore, one
could see on this chart, on any given day, how many orders are
scheduled, how many past due orders remain, how many scheduled
orders/past due orders have been completed, and how many remain by
workcenter.
So... Scheduled orders = Scheduled complete + Scheduled Not Complete
And
Past Due Orders = Past Due complete + Past Due Not Complete
Currently, I have built a separate query that shows each instance. One
query to show all orders that are scheduled for each workcenter, one
query to show how many scheduled work orders have been completed, etc.,
leading to 6 different queries. Is there a way to combine these
queries into one chart or spreadsheet that I can display on a form???
Hope that made sense.
Thanks,
Matt