I'm trying to select records from a query to make a report, but I need the records to remain in a particular order (random) as I choose them.
This is a report for a small laboratory. We get a list of maybe 10-12 patients that a physician wants information about. Currently to make the report for the doctors, we have all of our information in an Excel sheet and we cut data from that sheet and paste it into another, with the names in the same order that they appear on the original list.
Can anyone think of a way to do this with Access? I have a query with every patient and relevant data listed. I just need to figure out how to select them and keep them in the correct order (it is a completely random order though-not alphabetical or numerical). I did try adding an extra column to "rank" each record manually as I select it, thinking I could then run another query and sort by those rankings, but my query is too complex to be updateable and I couldn't add in the numbers. I also tried a form with two listboxes and arrows between them to move records back and forth, but the code is really over my head. I tried to copy several examples but couldn't get any of them to work for me.
Any ideas as to what else I could try? Thanks in advance to anyone that can help me!