Back to my Orienteering database.
The area where I do this is about 150 square kilometers. I've divided it up into 20 zones, labeled A, B, C ... A control is a member of a zone.
When I go out to check controls in the fall, I want to print up lists of controls in each zone in a format I can load them into my GPS.
In access I had to make a form that asked for a letter that ran a macro that ran a querry that would produce a file called exports.txt. And I had to do this separately for each zone.
My background is in perl. In perl or in any procedural language I would do something like this:
foreach $zone ('A' .. 'Z') {
Do a subroutine with $zone that creates $Zone.txt
}
Loop constructs are impossible in access. Does Alpha5 have the ability to run a querry on table A with filter parameters either specified in line, or in table B.
E.g. another example: The clues have 8 boolean fields depending on which races in the season I'm planning to use them. (This way I can set up multiple races in advance.) These fields are labeled R1 to R8
Now what I would like is
Table A: My clue table.
Table B: 8 rows each with a name, and 8 trinary fields that can be true, false, or don't care.
Query "Make Race tables" runs through Clues 8 times. Each time using one row of table B as it's criteria, and creating a new table called Name
So if B had a row
Race_1 T _ _ _ _ _ _ _
Then after the queery ran there would be a new table Race_1 that had all the clues that had R1 set to True. (A clue can be used on more than one race.)
Is this do-able?
The area where I do this is about 150 square kilometers. I've divided it up into 20 zones, labeled A, B, C ... A control is a member of a zone.
When I go out to check controls in the fall, I want to print up lists of controls in each zone in a format I can load them into my GPS.
In access I had to make a form that asked for a letter that ran a macro that ran a querry that would produce a file called exports.txt. And I had to do this separately for each zone.
My background is in perl. In perl or in any procedural language I would do something like this:
foreach $zone ('A' .. 'Z') {
Do a subroutine with $zone that creates $Zone.txt
}
Loop constructs are impossible in access. Does Alpha5 have the ability to run a querry on table A with filter parameters either specified in line, or in table B.
E.g. another example: The clues have 8 boolean fields depending on which races in the season I'm planning to use them. (This way I can set up multiple races in advance.) These fields are labeled R1 to R8
Now what I would like is
Table A: My clue table.
Table B: 8 rows each with a name, and 8 trinary fields that can be true, false, or don't care.
Query "Make Race tables" runs through Clues 8 times. Each time using one row of table B as it's criteria, and creating a new table called Name
So if B had a row
Race_1 T _ _ _ _ _ _ _
Then after the queery ran there would be a new table Race_1 that had all the clues that had R1 set to True. (A clue can be used on more than one race.)
Is this do-able?
Comment