Create a mountain climbing code

[akphidelt]

Hello all, I have a pretty weird request. I've been tasked to come up with a
little motivation program on access which uses climbing a mountain as a
metaphor. What I want to do is as peoples sales increase I would like them to
be higher on the mountain. I have a little sherpa dude that I use as the
individual people and it is a race to the top. So every time someone inputs a
new sale that person will move up on a relative scale on the mountain with
his little sherpa image.

Is there any way to set this up? I was thinking there has to be some kind of
code you can use that takes the distance of the line going from the bottom of
the mountain to the top and multiplying that by the current amount divided by
the end goal... then you can use this relative type reference to place an
image at a certain point on the form.

Any ideas?
Any help will be greatly appreciated.

Thanks!!

 

[Fred]

The main task that you're asking about is display, as the data side is very
simple. And to do exactly what you are saying, to position a small graphic
onto a bigger graphic based on a numerical value.

Possibly you could use the graphing options in Excell to see how close they
can get to what you want. But you might be resigned to using Access to
record and retriee the info and manually moving the little sherpa dudes in a
graphics program.