Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Strage Problem

Status
Not open for further replies.

rekhatr10

Programmer
Apr 2, 2004
67
US
Hi Everyone,
CR 7.0
SQLServer 2000

I have a very strange problem. I have 2 table appts & Char
The link is left outer join to Account#. What i want is even if no records are in char I still want to see records from Appts table. Under the EditselectionForumula->Group I have set if char.Desc <> 'PatientOrder'. When I clik on preview I see all the appoitments but I create the executable the result differs from the preview I just see only E& M Med or I don't see the patient name at all. What am I missing. Any suggestions will be helpful.

Thank you
Rekha
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top