Using the "I Will Type" option in a Lookup field which allows checking of multiple answers, how do I get the results to sort in non-alphabetical order in the field itself in Datasheet view? Background: I am BRAND NEW to Access as of last week, so am teaching myself from books and the Help button. My project is the creation of a searchable database for a large organization's local group meetings. There are about 250 groups, many of which meet on multiple days. How do I get the days of the week (all entered in the same field, selected by Lookup checkboxes sourced from an "I Will Type" list) to sort into day-of-the-week order instead of alphabetically?
Please do not hesitate to ask for clarification, as I'm not confident in my ability to adequately express myself in Access-ese.
Thank you!
KrsyLu
Datasheet with checkboxes Excel sheet with results