Sorting a value list

[JariV]

Hi,

I have a value list (pop-up menu), whose values are pulled up from a field in another file. That field is a compilation of 2 date fields in that file (DateToText(PeriodStart)&"-"&DateToText(PeriodEnd))- ie. it is a text field.

I'd like these (text) values in the pop-up menu to be sorted by PeriodStart, now they seem to be in random order.

Among other things, I've tried to create a related "pop-up menu values"- field in the main file, using a relationship that sorts the related records by PeriodStart, and pull the values for the pop-up list from that field, but that doesn't seem to have any affect on how the value list is sorted.

Now I'm starting to wonder whether this is at all possible...so any help with this is greatly appreciated.

Jari V.

[-Queue-]

You could create a calculation text field of Year(PeriodStart) & Right( "0" & Month(PeriodStart), 2 ) & Right( "0" & Day(PeriodStart), 2 ) and base your list on this field. It will sort appropriately since the year is first and the format is consistent.

[JariV]

Thanks a lot,

I even added the PeriodEnd-values to the calculation text field (now the pop-up menu displays the whole range) - still sorts properly.

Jari V.