Hello
I have been working on a medical database (novice level knowledge) and have managed to get in most of what I would like in tables, forms and reports.
one problem is that I cannot figure out how to stop the automatic alphabetizing of my data.
for example, one column is for ultrasound findings of a blood clot inside the leg veins. I have listed off different anatomic names for veins in order of lowest down (closer to ankle) to highest up (closer to belly), repeated for left vs right. my form works well as when I click the multiselect drop down menus, all the items are listed in a logical order (first left and from low to high, then all the right sided veins from low to high). but when it shows up as text on my form or more importantly on my reports, it automatically comes out in alphabetical order. this makes it nonsensical to read.
any thoughts on how to stop this? I have not applied any sort filters (quite honestly don't know how to -- otherwise I could probably answer my own question) so I assume this is default. a step by step approach would be helpful
thanks in advance!