Search results

Thank you! This resolved my issue. Appreciate it!

Hi CJ, Below is the query. Focus is on column PAY_PAYROLL_ACTIONS.DATE_PAID. Could you possibly provide a clearer example? Thank you! SELECT PAY_PAYROLL_ACTIONS.FULL_NAME, PAY_PAYROLL_ACTIONS.ASSIGNMENT_NUMBER, PAY_PAYROLL_ACTIONS.PAYROLL_NAME, PAY_PAYROLL_ACTIONS.PERIOD_NAME...

I have a table with the following values. EMPLLOYEE_ID JOB PAY_DATE LOCATION Most employees have 10 to 15 rows. I only want to pull ALL rows for employees ONLY if there is a distinct count from DATE_PAID greater than 1. There are cases where an employee might have two pay checks...

Hi Access Experts! I have a question that might be fairly easy for you. I have one table let's call is table1. It contains about 5 columns with standard employee data with about 10,000 rows of data containing about 1,150 employees. All employees have multiple rows of data. There is one column...

Thanks. That will only pull rows where there is a value. I need of there is a value for all rows.

Hi Access Experts! I have a question that might be fairly easy for you. I have one table let's call is table1. It contains about 5 columns with standard employee data with about 10,000 rows of data containing about 1,150 employees. All employees have multiple rows of data. There is one...