Recent content by Ron_Mowry

I have 2 tables Employee list and March Connected . The Employee list table has all the employees and managers from my my local department and the March Connected table has a list of all completed saled from my local department and sales that are completed by agents at another location but...

I am tring to add a field not tied to any tables with the header Manager and I want each field below it to read unknown for the amnt of records that are being displyed from the 2 table query.

I am having problems trying to figure out how to create the following query. I have 2 tables the first table Employee List is a list of all of the employees that work at my location, the fieldsI will be using in this table are as follows( Manager, Employee Name, Employee # ) The second table...

I have created an unmatched query that returns employees who are listed in my Sales table but are not listed in my employee list table. Now this query retunrs null data for manager since there is no manager field in the sales table. but I need this query to return a manager field and if there is...

Duluter, Thank you this worked great for me.

I have 2 tables Employee_list containing (Manager, Emp_Name, Emp_Number)Table 2 is March_Connected that includes the following fields( RGU(This can be labled either Digital, Data, Video, or Phone)) & Emp_Number). If the employee does have a sale under the RGU colum it will show up as either...