GromBoy you have broken Thread Selecting 1st Appt Date

[IanWaterman]

SQL you pasted has not wrapped and broken thread, no one can now reply.

Dont't think you can just add max and min to that query as you will probably bring back wrong data from other tables.

You need to replace the Patient table with a command similar to the SQL I sent earlier.

Ian

 

[lbass]

Ian,

You should red flag posts that are too wide. You can get to the red flag box by placing your cursor above the "Thank SoandSo" text, and then hitting the tab key twice and then hitting enter. I already red-flagged the post in question for you.

-LB

 

[gromboy]

Sorry guys.......
Won't happen again
Steve