Attached is a DB for resident (patient) care. I created queries for several reports ordering by room in the query however the following reports sort alphabetically and I don't know why. Can anyone help?
ResidentRoster-allResidentsalphabeticalrpt
AlertchartingEmeraldrpt
AlertchartingHighlandsrpt
AlertchartingLTCUnitrpt