how do I rank selections in a multivalue access field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GenAMES - 12 Jun 2007 13:55 GMT

I want the order in which I select values in a multi-valued field to be
reflected in the order in which they're displayed, rather than being
displayed in the order in which they appear in the full range of available
selections such that the 1st item selected is the most important, the last
value selected is the least important etc.

Reply to this Message

KARL DEWEY - 12 Jun 2007 15:30 GMT

Not tried --
Have event of selecting to append records to a sort table that is joined in
your query. The sort table will need an autonumber field to sort on. You
will need to have a delete query run on the sort table on opening the form
(before selecting).

Signature

KARL DEWEY
Build a little - Test a little

> I want the order in which I select values in a multi-valued field to be
> reflected in the order in which they're displayed, rather than being
> displayed in the order in which they appear in the full range of available
> selections such that the 1st item selected is the most important, the last
> value selected is the least important etc.

Reply to this Message