Hey all,
I have a query with several tables in a relationship: Table 1: Power Plant info, Table 2: Sales Rep info...and a couple others. I have a filter for the power plant name that is given by the user on another form.
On a report I need to see certain controls from the Power plant table and corresponding controls from the Sales Rep table.
My problem is: I don't have a sales rep associated with each power plant and if the user chooses a power plant that doesn't have a sales rep associated with it, the report and query comes up blank. I need to show four controls from the Sales Rep Info Table on the report (first name, last name...). The report is referenced from the query.
Is there a way for access to ignore the Sales Rep fields if none exist for the power plant and show the remaining information, leaving the "null" values blank?? like an expression in the criteria?
I have a query with several tables in a relationship: Table 1: Power Plant info, Table 2: Sales Rep info...and a couple others. I have a filter for the power plant name that is given by the user on another form.
On a report I need to see certain controls from the Power plant table and corresponding controls from the Sales Rep table.
My problem is: I don't have a sales rep associated with each power plant and if the user chooses a power plant that doesn't have a sales rep associated with it, the report and query comes up blank. I need to show four controls from the Sales Rep Info Table on the report (first name, last name...). The report is referenced from the query.
Is there a way for access to ignore the Sales Rep fields if none exist for the power plant and show the remaining information, leaving the "null" values blank?? like an expression in the criteria?
