Criteria to Display All Records Null and Is Not Null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with this record source:
tblPKCGMaterialAttributes.txtProfileID)) INNER JOIN
tblPKCGFinishingAttributes ON tblProfiles.txtProfileID =
tblPKCGFinishingAttributes.txtProfileID) INNER JOIN tblProfilesRevisions ON
(tblPKCGPhysicalAttributes.txtProfileID = tblProfilesRevisions.txtProfileID)
AND (tblProfiles.txtProfileID = tblProfilesRevisions.txtProfileID) WHERE
(((tblProfiles.Type)="CG"));

The report only displays records that have revision dates.

What criteria do I use to make the report display all records with or
without revision dates? Is this maybe a join issue?

Any guidance would be appreciated!

Thanks!
 
hi,
yes it is a join issue. you will need to right join
instead of inner join.
Look up joins in helps.
also in the query in design mode right click the join. be
careful. two popups can popup. you want the one that says
join properties. don't click the join close the the table.
click in the center of the join.
-----Original Message-----
I have a report with this record source:
tblPKCGMaterialAttributes.txtProfileID)) INNER JOIN
tblPKCGFinishingAttributes ON tblProfiles.txtProfileID =
tblPKCGFinishingAttributes.txtProfileID) INNER JOIN tblProfilesRevisions ON
(tblPKCGPhysicalAttributes.txtProfileID = tblProfilesRevisions.txtProfileID)
AND (tblProfiles.txtProfileID =
Click to expand...
tblProfilesRevisions.txtProfileID) WHERE
 
Unfortunately, John's post got messed up with the SQL String but it looks
like a Left Join is required to the tblProfilesRevisions, i.e. this Table is
the "right" Table of the Join.
 
Thanks, everyone!

Van T. Dinh said:
Unfortunately, John's post got messed up with the SQL String but it looks
like a Left Join is required to the tblProfilesRevisions, i.e. this Table is
the "right" Table of the Join.
Click to expand...
 
Back
Top