Suggestion on how to do this complicated Report

[rekhatr10]

Hi Everyone,

SQLserver2000
crystal 7.0
I have to come up with a report where a patient has an appointment and the attending or the resident did not do a note on the pt. the two tables are mwappt and cldochist and the joined fields are acct number. I am using date as a restriction as I don't want eveything in the table and also in the mwappts . I have to check in cldochist if there is a record for that patient and if it is is the date right? I am totally lost on how to do this report. Any suggestion will be helpfule Please help!!

Thank you
REkha

 

[Turkbear]

Hi,
If I understand the problem, you should be able to link the tables (mwappt -> cldochist) by acct_number and Date and make it a left outer join.

In the report place data from both tables ( the fields you want, like acct_number [from BOTH tables] for instance) -

Any acct number that only appears once would mean no matching record in cldochist.

You could also try making the link a NOT EQUALS so the records returned from mwappt would ONLY be those that did not match in cldochist.

 

[rekhatr10]

Turkbear

Thank you I will try your suggestion tomorrow as I have to test things on another project. I had a question regarding the date one date is date & time and the other one is just date. Can I still link on the date?

Thank you
Rekha