Combining two queries for one report

[ebarrera]

I have a database which has two tables (instructional and non-instructional assignments). The Instructional table is a table that is imported from our campus database (data entry done by canpus). The Non-Instructional table is a table that is manually keyed and maintained by me. A faculty member can exist in either table and with an assignment. I need a query that looks at both tables and gives me any assignments that may be assigned. I have created two seperate queries because each has a seperate payment process. Now I have to join the two queries to give me the assignments and their pay rates.

The reason I need one query is because I need to calculate total cost and total work load in a semester. Both tables are the same instructure, but has data that changes on a daily basis while the other is not.

I am not familiar with amending queries and am not a programmer. Can this be done and if so can be done through the design view?

 

[dsfcom]

You should be able to create one query using both tables. Join them by the unique field (whatever it is; say [FACID]) and then add the fields you need to the query and group sum the pay data. The fewer fields added the better so it will sum properly.