Access Query Question

  • Thread starter Thread starter Job
  • Start date Start date
J

Job

I have three tables; qry_Unique_EmpID_union, z_qry_ID_and_Name
,z_qry_Uniq_Names_Pyr . qry_Unique_EmpID_union has a list of unique values
for ID and FinOrg. I'm essentially trying to match a name to each of these
unique instances with the following query. However, this doesn't give me
the unique values, it duplicates the rows. Anyone have any suggestions?


SELECT qry_Unique_EmpID_union.ID, qry_Unique_EmpID_union.FinOrg,
IIf([z_qry_ID_and_Name.Name] Is
Null,[z_qry_Uniq_Names_Pyr.EmployeeName],[z_qry_ID_and_Name.Name]) AS
EmpName
FROM (qry_Unique_EmpID_union LEFT JOIN z_qry_ID_and_Name ON
qry_Unique_EmpID_union.ID = z_qry_ID_and_Name.ID) LEFT JOIN
z_qry_Uniq_Names_Pyr ON qry_Unique_EmpID_union.ID = z_qry_Uniq_Names_Pyr.ID;

Cheers,

Job
 
Thanks Klatuu. For some reason when I did that I thought I still had dups,
but now I run again and seems to be fine.

Cheers!

Job

Klatuu said:
SELECT DISTINCTROW qry_Unique_EmpID_union.ID,
qry_Unique_EmpID_union.FinOrg,

Job said:
I have three tables; qry_Unique_EmpID_union, z_qry_ID_and_Name
,z_qry_Uniq_Names_Pyr . qry_Unique_EmpID_union has a list of unique
values
for ID and FinOrg. I'm essentially trying to match a name to each of
these
unique instances with the following query. However, this doesn't give me
the unique values, it duplicates the rows. Anyone have any suggestions?


SELECT qry_Unique_EmpID_union.ID, qry_Unique_EmpID_union.FinOrg,
IIf([z_qry_ID_and_Name.Name] Is
Null,[z_qry_Uniq_Names_Pyr.EmployeeName],[z_qry_ID_and_Name.Name]) AS
EmpName
FROM (qry_Unique_EmpID_union LEFT JOIN z_qry_ID_and_Name ON
qry_Unique_EmpID_union.ID = z_qry_ID_and_Name.ID) LEFT JOIN
z_qry_Uniq_Names_Pyr ON qry_Unique_EmpID_union.ID =
z_qry_Uniq_Names_Pyr.ID;

Cheers,

Job
Click to expand...
Click to expand...
 
Good, glad it worked for you

Job said:
Thanks Klatuu. For some reason when I did that I thought I still had dups,
but now I run again and seems to be fine.

Cheers!

Job

Klatuu said:
SELECT DISTINCTROW qry_Unique_EmpID_union.ID,
qry_Unique_EmpID_union.FinOrg,

Job said:
I have three tables; qry_Unique_EmpID_union, z_qry_ID_and_Name
,z_qry_Uniq_Names_Pyr . qry_Unique_EmpID_union has a list of unique
values
for ID and FinOrg. I'm essentially trying to match a name to each of
these
unique instances with the following query. However, this doesn't give me
the unique values, it duplicates the rows. Anyone have any suggestions?


SELECT qry_Unique_EmpID_union.ID, qry_Unique_EmpID_union.FinOrg,
IIf([z_qry_ID_and_Name.Name] Is
Null,[z_qry_Uniq_Names_Pyr.EmployeeName],[z_qry_ID_and_Name.Name]) AS
EmpName
FROM (qry_Unique_EmpID_union LEFT JOIN z_qry_ID_and_Name ON
qry_Unique_EmpID_union.ID = z_qry_ID_and_Name.ID) LEFT JOIN
z_qry_Uniq_Names_Pyr ON qry_Unique_EmpID_union.ID =
z_qry_Uniq_Names_Pyr.ID;

Cheers,

Job
Click to expand...
Click to expand...
Click to expand...
 
Back
Top