ASP Contestant Rank query from ACCESS DB

.asp query for Fishing Tournament DB Query would be by Web Form user input of the contestants registration # ([url removed, login to view]). Results need to show all fish caught by that contestant and what Rank each fish is by its fish type. Rank is specific / limited to an individual Registration Division* ([url removed, login to view]) NOT all fish of that type. *RegType 1 & 3 = Boat Division, 2 & 4 = Shore Division, 5 = Youth Division Output: Example -- Name : John Smith Reg ID: 9954 Registration Type: Boat Dvision Report Date / Time Your Fish No. Type Weight Current Rank ------------ ----- ----- ---------- 1 Chinook 28.26 lbs 3 2 Laker 21.24 lbs 7 Etc. END Example Also Query should only consider registrants w/ an mm/dd/CURRENT YEAR (eg 07/10/03) Date ([url removed, login to view]) Key factor is this is a highly time and budget (This is a not for profit gig) sensitive project. If we cannot get this ready (econimically) for Tomorrow AM (Sat 7/19) It will not be worth doing this year. Note: Fish Type Key: 1 = "Chinook" 2 = "Coho" 3 = "Laker (Boat Only)" 4 = "Brown Trout" 5= "Rainbow Trout" 7 = "Atlantic Salmon" 8 = "Golden Rainbow" 9 = "All Other"

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

W2k IIS Using the Jet.OLEDB.4.0 Driver

ASP Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #2954626

About the project