Can Access be used to do group distribution (best fit)?

[gledenbach]

I am trying to create a best fit distribution program for assigning kids
from several schools to seating areas in a theatre.

 

[Steve]

Hello Greg,

I provide help with Access, Excel and Word applications for a small fee. I
can help you with your application. Contact me.

Steve
(e-mail address removed)

 

[Douglas J. Steele]

Please stop violating the terms of use for these newsgroups, Steve. You know
very well soliciting for work is not permitted.

 

[John W. Vinson]

I am trying to create a best fit distribution program for assigning kids
from several schools to seating areas in a theatre.

There's nothing builtin to do this; you would need to create either a query or
VBA functions to do it. This can be a very complicated algorithm depending on
what constitutes a "best fit"! What constraints do you need to apply?

 

[John... Visio MVP]

Hello Greg,

I provide help with Access, Excel and Word applications for a small fee. I
can help you with your application. Contact me.

Steve
(e-mail address removed)

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

 

[John... Visio MVP]

Hello Greg,

I provide help with Access, Excel and Word applications for a small fee. I
can help you with your application. Contact me.

Steve
(e-mail address removed)

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

 

[John... Visio MVP]

Hello Greg,

I provide help with Access, Excel and Word applications for a small fee. I
can help you with your application. Contact me.

Steve
(e-mail address removed)

Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

John... Visio MVP

 

[roccogrand]

Greg,

Yes this can be done with Access but as John said, it requires a lot of
coding. One of the members of the local Access users group demo'ed a similar
app for pet hotels a couple years ago. It was an impressive piece of work.
At this point in time, I couldn't start to tell you how he did it.

David

 

[James A. Fortune]

There's nothing builtin to do this; you would need to create either a query or
VBA functions to do it. This can be a very complicated algorithm depending on
what constitutes a "best fit"! What constraints do you need to apply?

John,

That's a great answer. One particular "best fit" I encountered was
for randomizing the placement of participants in a tournament subject
to certain conditions. The "best fit" that was decided upon was to
keep people from the same league from encountering each other for as
long as possible in the brackets. There was no "seeding" in the
tournament and it was desirable not to have the players from a strong
league knock each other out early. Plus, it's no fun to travel a long
way to a tournament just to encounter someone you compete with
regularly.

James A. Fortune
(e-mail address removed)

If we wanted to be accurate, it would have to be something like:

'I' before 'e', except after 'c', or when sounded as 'a,' as in
neighbor and weigh
or when it appears in comparatives and superlatives like fancier
or when the 'c' sounds as sh as in glacier
or when the vowel sounds like 'e' as in seize
or 'i' as in height
or it shows up in compound words as albeit
or when it shows up in 'ing' inflections of verbs that end in 'e' like
queueing
or occasionally in technical words that have a strong entomological
link to their parent languages such as cuneiform and caffeine
and in numerous and other random exceptions such as science, forfeit
and weird
and that doesn't even rhyme.

-- Cory Stamper, Associate Editor, Ask the Editor http://www.merriam-webster.com