I want to use the record number to be a part of an equation. I need to display bout numbers in an 8-man wrestling bracket.
I want to use the record number to determine how many bouts in total we have wrestled to that point.
For example: 1st round, 4 matches, 2nd weight class would be 5 matches so far. 2nd round if there were 16 weight classes would be 16 * 4 + 1 and so on.
Another example:
2 (2nd weight class) * Number of bouts in a round + 1 = the first bout number in the second round.
I need to reference the record number in order to do that. How can I put that number on a form.
Thanks for the help.
Keith
I want to use the record number to determine how many bouts in total we have wrestled to that point.
For example: 1st round, 4 matches, 2nd weight class would be 5 matches so far. 2nd round if there were 16 weight classes would be 16 * 4 + 1 and so on.
Another example:
2 (2nd weight class) * Number of bouts in a round + 1 = the first bout number in the second round.
I need to reference the record number in order to do that. How can I put that number on a form.
Thanks for the help.
Keith