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?

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.