If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Value Order in MVF's
First of all, I am well aware of the pitfalls of multi-valued fields, so
please don't chastise me for using them. I am working with a very small database that will never grow beyond Microsoft Access. However, I have a question for anyone who may be willing and able to help. I have created a multi-valued field for the days of the week that college classes meet (M, T, W, R, F). The problem is that when I print a report of these classes, Access arranges the days of the week in alphabetical order, so R comes before T, and F before M. Is there any way to specify the order that these records appear in my reports or make Access understand that these values correlate to the days of the week? |
#2
|
|||
|
|||
Value Order in MVF's
BTW, with the right form, entering the data is very easy and friendly for the
user. |
#3
|
|||
|
|||
Value Order in MVF's
I think that you just ran into one of those problems/limitations with MVF's
that they were talking about. One idea. Why not make a 2 field (3 with probably-not-needed PK field) table for instances of day of the week scheduling of a class. Use a chronological code 1 = Monday, 2 = Tuesday. Put a FK of the class ID in there, and link it to the class on that. Then make a tiny 2 field translation table that converts the code to your desired abbreviation. And link on that code. Now everything that you want for your report is right there for you. Sort on the code and display/print the abbreviation. |
Thread Tools | |
Display Modes | |
|
|