Solution found
Ok, a co - worker helped me with my issues.
For the issue where I was getting more results than just the parameter ID=3 I passed was because I have a wildcard in my code. It was pulling all with ID=3 (all starting with 3). Removing the % cleared up the multiple records...
Ok, still need help...when sorting
I was able to figure out in order to create one result.asp page, I input the direct path, ex: //test/testresults.asp?=3
This works when I am directed to testresults.asp, I see the results of my query with the parameter ID=3...but I have extra code to make...
Ok, on my main.asp page I have a menu, when the user click on the main menu it expands showing links underneath when the user chooses/clicks on link it takes them to results.asp (displaying results from sql query where I have a where clause - ex. where EQID=1). So right now I making extra work...
Currently there is a sql database using IIS for web access for users on my server, can I have an access database and also create web pages for users to access as a front end without any problem?