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!

Register Log in
  • Congratulations SkipVought 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

rekhatr10

Programmer
Apr 2, 2004
67
0
0
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.

Similar threads

Cpreston
  • Locked
  • Question
Remaining Text does not appear problem 2
Replies
10
Views
137
Cpreston
Cpreston
wld1957
  • Locked
  • Question
Report Form Problem - What can it be? 1
Replies
3
Views
44
wld1957
wld1957
Cpreston
  • Locked
  • Question
Barcode Problem
Replies
1
Views
68
Cpreston
Cpreston
JasonKaufman
  • Locked
  • Question
CSV export of field problem
Replies
4
Views
46
JasonKaufman
JasonKaufman
gsmithmme
  • Locked
  • Question
Problem with Running Total 1
Replies
5
Views
54
gsmithmme
gsmithmme

Part and Inventory Search

Sponsor

Back
Top