Search found 2 matches
- Wed May 15, 2019 8:20 am
- Forum: Main Forum
- Topic: Query Help!!
- Replies: 5
- Views: 6556
Re: Query Help!!
So that does help ordering this one report by status, but I am really hoping to actually break the report to only showing me one status. My goal is to be able to use this query to break into three separate reports (1 for completed, 1 for treatment planned, and 1 for scheduled)
- Tue May 14, 2019 1:09 pm
- Forum: Main Forum
- Topic: Query Help!!
- Replies: 5
- Views: 6556
Query Help!!
I have been trying for way too long to edit this query to what I'm looking for. The current query I am using is: SET @pos=0, @FromDate='2019-01-01' , @ToDate='2019-01-31'; SELECT @pos:=@pos+1 as 'Count', pa.PatNum, pc.ProcCode as 'Code', abbrdesc as 'Description', ToothNum, DATE_FORMAT(pl.DateTP,'%m...