Two tables needed to produce one report

[Stephenson]

Hello all,



I have two tables, EmployeeWorkLog and VendorPurchaseLog. I have forms to input data into these tables and need to pull a report to show fields from each of them. They share the fields, JobID, ServiceID and Date. I've tried queries, but am still learning how to create them. There will be many circumstances where there will not be any records in my table VendorPurchaseLog when there are records in table EmployeeWorkLog. This alone has me confused.

How can I create a report that shows records for two tables with overlapping fields even when there may be "null" results in the other?

Thank you for having a look.

[CJ_London]

in a query use a LEFT JOIN between the table which 'always has the records' and the table that doesn't

SELECT *
FROM EmployeeWorkLog LEFT JOIN VendorPurchaseLog ON EmployeeWorkLog.jobID =VendorPurchaseLog.jobID AND EmployeeWorkLog.ServiceID =VendorPurchaseLog.ServiceID AND EmployeeWorkLog.jobDate =VendorPurchaseLog.jobDate

Note - Date is a reserved word so if your tables use this as a field name, I strongly recommend changing it

Alternatively use a right between the table that doesn't and the table that does

SELECT *
FROM VendorPurchaseLog RIGHT JOIN EmployeeWorkLog ......

[Stephenson]

Thank you Ajax.

This works great. I appreciate your help.