Hi Rick, Lets say I want to sort Ranks (they are not alphabetical but have a hierarchy of their own). I added a number to the front of them in the drop down list so I could sort them by number, but how do I DISPLAY them in the report WITHOUT the number being visible?
Reply from Richard Rost:
Use three fields. Have an ID, a SortOrder, and the RankName. In a query, you could create a concatenated field for your display value in the combo box but still only show the RankName in your report.
DisplayValue: SortOrder & ". " & RankName
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 6.
