Hekp with a better solution for an Ezcel workbook but wantcto try to make it with Access instead

[Support4Free]

Hi !!



Need some help, today we use a solutuon for this made in Excel, but I want to find a better and smarter solution.

Excel workbook have 1x tab with all the different elements, 100+.

Each routine include a serie of 10 elements.

Tab 1, 2, 3, 4, 5, 6,7... info about athlete, team,, age, the 2x riutines each with 10 different elements, code for that element and difficultly score...

Now you have to copy and paste code from tab with all 100+ elements or mabually type in.
The difficult for each element is automatic added and total difficultly too.

what I want to do in Access is to choose element from drop down list, but store the code and also automatic show the difficulty for that element. Everything is in a 3x colums Excel sheet... Element, Code and Difficult.

So in a form I want to type in athlete, team, age, what he will compete in (class), sex (m/f)

The 2x routines, each with 10x elements and tge difficult for each element.
Below show the total difficultly score points for the routine.

[rpeare]

If you're still working on this it sounds like you're trying to develop a way to calculate the difficulty of a sport like diving or gymnastics where the addition or removal of elements affect the difficulty of the overall routine/dive. If that's the case. It shouldn't be too hard to do the calculation. Saving the 'routine' so you can bring it up, modify it, etc (i.e. if it's gymnastics you and you have a 'base' routine, or several base routines, and you modify elements within that routine to create a 'final' routine) shouldn't be too hard either, from there it should not be too hard to assign a routine to a person as long as your data structure is good.

I am not sure what exactly you're after though because the original post isn't clear, is the scoring element that's a problem? is it storing the routines?