Value Order in MVF's

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

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?
 
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.
 
Back
Top