F
F0zziebear
I have an excel report which draws data from access. The excel table looks
like this:
Each project is reviewed by two people
Reviewer Name | Reviewer1 | Reviewer2 | Total last 12 months
AA x y x+y
This is repeated for 3 months and 1 month (so the querry uses a date between
to work that out)
x is a create-tabel query and so is y. I want to create one table for these
queries (in total 6 per reviewer) and import that table into excel. I would
also need to add the reviewer 1 and 2 in the table so as to import it in one
go.
Can you help on how to create a table from these six queries, or is there
another way of doing this?
Let me know if you need further clarification
like this:
Each project is reviewed by two people
Reviewer Name | Reviewer1 | Reviewer2 | Total last 12 months
AA x y x+y
This is repeated for 3 months and 1 month (so the querry uses a date between
to work that out)
x is a create-tabel query and so is y. I want to create one table for these
queries (in total 6 per reviewer) and import that table into excel. I would
also need to add the reviewer 1 and 2 in the table so as to import it in one
go.
Can you help on how to create a table from these six queries, or is there
another way of doing this?
Let me know if you need further clarification