hey well i have made a database for a running club and have created all of the input tables and some of the reports, now the only two things i have left to do is create exception reports, which will be fed from a query. the things i need to do are
exeption reports of runners entered for a specified race but who did not complete (finding people who did not complete will mean that in their time field it will be 00:00:00, but i need to search for races, each race has a specific date)
and then sorting through a table to find all people in a table where their status will eaqual either member, non-member or none
any help would be a lot of help, i have a copy of the database if anybody wants a look if they think they can help
exeption reports of runners entered for a specified race but who did not complete (finding people who did not complete will mean that in their time field it will be 00:00:00, but i need to search for races, each race has a specific date)
and then sorting through a table to find all people in a table where their status will eaqual either member, non-member or none
any help would be a lot of help, i have a copy of the database if anybody wants a look if they think they can help
