Left Outer Join Question

[rekhatr10]

Hi Everyone,

CR 7.0
SQLServer 2000

I have 2 table one with appts and one note. I want all the records from tablea. I am using the date criteria from table a and createdate for the record selection. That is where I am having problem. If I remove the record selction criteria for createdate, I get all the records from table a. Is there a work around or how would I tackle this problem. I have to have the criteria in table b as there would be old records which I don't want displayed.

Tablea Tableb
account account
date createdate

Thank you for your help
Rekha

 

[hilfy]

I'm sure there's a better way of doing this but the first thing that comes to mind is to use the section suppress formula to suppress data that doesn't meet your date restriction.

-D

 

[GJParker]

Try changing the selection criteria to check for NULL createDate

IsNull({TableB.CreateDate}) or {TableB.CreateDate}..Your Criteria

HTH



Gary Parker
Systems Support Analyst
Manchester, England