access 97 macros

[DNA]

I am setting up a program for a local swimming club in access 97,, the database is getting there but i am having trouble with the formula conversion's.
That formula is quite involved and i don't think i can do it. Iam wondering if anyone would be interested in having a look at the formulas and see if it is possible to write the macros /modules.

[opiate]

dna,

You would be amazed at the knowledge of some of the programmers that browse the "Programming" forum. I myself have had allot of different scripting experiance such as VBScripting, JavaScripting, VisualBasic, VBA for MS-Office and others.

Just copy and past your examples in a post and comment the formulas. I'm sure there is someone here who can help you. <IMG SRC="smilies/wink.gif" border="0">

[DNA]

I am wondering if anyone would like to have a go at a little visual basic. This is a small part of a swim program, apparantly, access 97's vb, can do the job.!! If anyone is interested i can send a small db.

A Season of meetings is held each year and the following details are required to be kept about each meeting.
The meets comprise races in the following strokes, Free style, Backstroke, Butterfly, and Breaststroke.
Each stroke has a race in the following distances 20,30,50,100 metres.

All PB times for each member are moved to start of the season PB, and will serve as the PB for the first time that event is swum by in the member for the new season.


Times for each race type are and points allotted for all individual races as per follows.

If the member is a new member or it is the first time he/she has swum a particular race type. Then the points allotted for that race are 3.

? If two seconds or more faster than PB , 6 points,
? If one second faster or more, and less than two seconds faster than PB, % points.
? If within one second faster or slower than PB, 4 points
? If more than one and up to two seconds slower 3 points.
? If two seconds or more and up to three seconds slower 2 points.
? If 3 or more seconds slower than PB, 1 point.
? If no participation in that racetype then zero points.
If a member only swims 20 metres, then 2 points are awarded regardless of the time.

If member away on representative duties then member is allotted four points for each individual.

PBS is determined:
For short distance less then 100 m
If one point is allotted for a race type and it is the third successive time that a one point is allotted for that race type
THEN
The new PB is the median of the time for that occasion and the proceeding two occasions that racetype was swum AND the points allotted for this event are changed to four. This new PB will appear on the report for the meet being reported on.
ELSE
The new PB for that racetype is the lesser of the existing PB and that race result for that racetype. The new PB will appear as the PB on the report about the meet following the meet in which achieved. The swimmer can see by how much has improved.

For individual long distance;
The PB is the best time swum by the member prior to that date.