Help with creating query or creating report

N

Need Help

Sample
Start time 6:00am end time 11:00am
HoundID JudgeID TimeScore Score
333 2 9:00 35 keep and count
333 4 9:03 30 keep and do not count
333 3 9:10 25 keep and count
333 2 9:50 15 keep and count
333 9 10:00 35 keep and count
333 4 10:15 20 keep and count
333 3 10:09 25 keep and do not count
323 2 10:10 35 keep and count
343 1 10:34 20 keep and count
343 10 10:45 15 keep and count
343 2 9:00 35 keep and count
Need total for each hounded
Per each HoundID all scores much be counted if over a 10 minute time
interval from each time HoundID was scored. No to scores can be within a 10
minute time interval from each other per hound ID.
For example HoundID 333
9:00 35
9:10 25
9:50 15
10:00 35
10:15 20
Total 130
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top