Search results

  1. R

    How to pull all records if distinct count > 1

    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...
  2. R

    Need to pull all records in one query if a value exists?

    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...
  3. R

    How to pull all records in one query if a value exists?

    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...
Back
Top Bottom