Search results for query: *

Thanks for taking the time to explain. However, I have found another problem. If I am in Access and I run the query using the following parameters (,2,1,) both rows will be deleted. But when I pass the the same parameter string from an ASP page the query will only delete the Pkey of 2 and...

This example appears to be working but I'm not quiet sure I understand why it is working. Could you please take a minute to explain. When I researched the Instr function it suggested that it will return the index location of the string being search when it finds the match. If that is the case...

I tested your solution above but it does not work correctly. Here is my sample table. PKey Description 3 Sample one. 8 Sample two. 38 Sample thirty eight. If I use your above query and pass the parameter (,38,) then ALL three rows are deleted. Thanks in advance for any other...

Here is my SQL statement. DELETE * FROM TableA WHERE PKEY IN ([paramIDs]) When I am prompted for the param I enter id numbers separated by comma, ie 1,2. This will not work. I know this is probably a simple fix. Please help.

I have one table that I need two counts from. The table holds information about a sports game. I want the number of games won and the number of games tied for a given team. Table: Game Fields: Game_ID,Home_Team_ID,Away_Team_ID,Win_Team_ID If the game was a tie then Win_Team_ID = -1 instead...