My application assigns a case number to tblCases. The case number is not the PK of the table as the table represents cases for multiple Outbreaks (parent table). My issue is that I want my users to select from a combo list of cases for the current outbreak and I want the case numbers to appear in sequential order. I also want the text "Select Case" to appear in the combo before the user picks a case.
The problem is that the Union query does not present the case list in numerical order. The query without the Union does present the list in numerical order.
I have uploaded the file UnionQueryIssue.docx showing the table schema, the standard query sql and datasheet and the Union query sql and datasheet.
I have tried a number of workaround be keep ending up with the same results.
Any suggestions?
Posted by: argeedblu@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar