Anesthetic medications delivered query for Anesthesia Module

[wjstarck]

Here is a query that will output the patient demographic data, Anesthetic Med Name, Qty Given and Qty Wasted for a given time period:

Code: Select all

SELECT anestheticrecord.AnestheticRecordNum,anestheticrecord.AnestheticDate, patient.PatNum as 'Patient#',patient.LName,patient.FName,
patient.Gender,patient.Birthdate,patient.Address,patient.Address2,patient.City,patient.Zip,patient.HmPhone,patient.WirelessPhone,
anesthmedsgiven.AnesthMedName,anesthmedsgiven.QtyGiven,anesthmedsgiven.QtyWasted
FROM anestheticrecord
LEFT JOIN anesthmedsgiven ON anesthmedsgiven.AnestheticRecordNum = anestheticrecord.AnestheticRecordNum 
LEFT JOIN patient ON patient.PatNum = anestheticrecord.PatNum
WHERE DATE_FORMAT(anestheticdate,'%Y-%m-%d') >= '2011-01-01' AND DATE_FORMAT(anestheticdate,'%Y-%m-%d') <= '2011-03-31'
ORDER BY anestheticdate ASC

Just copy and paste this into the box at the top of Reports > User Query and click 'Submit Query'. This report would give you all the meds delivered in the first quarter of this year. For different time periods just change the date ranges. It sorts ascending, so if you want descending sort, just change the 'ASC' to 'DESC'.

If you want to pretty up the output, click the 'Export' button in the lower right of the User Query window and save it as a .xls file. Then you can open it in Excel and format it however you like.

If anyone needs any other type of Anesthesia-related queries for their practice, just let me know.

[Roy Bloom]

Thanks Bill.