I have a query "qryUSAACLaims" that I am using as a record source for a report. I am trying to figure out how to use that output and include it in another record source for the report.
The table I am trying to include is called "tbldocuments" records are created in that table when the user creates a report ime_doctor or RecordsReview. The issue I am having is I have to use that table to determine another unbound field on the report called Duedate.
THe issue is , that certain rows from QryUSAACLaims do not show up on the report because a report has not been created yet. I am trying to figure out how to include those records on the report. I have included the sample database which does not include any sensitive data.
The record source I need help with is the query Statusreport.