Help with Syntax on db delete using ID (resolved)

[Iat]

Hi,
Can anyone please help me to understand the conversion of this syntax used in the following two scenarios:

When execute, I get the following error message from the 1st set of code:
"No value given for one or more required parameters."

Thanks,

Phillip

'This code does NOT work
dim test as string
test = LTrim(tmpSTR(UBound(tmpSTR)))    ' test = 1
Set MyRecSet = MyConn.Execute("DELETE * FROM table1 WHERE ID =" & test)

'This code does work
'dim test as string
'test = LTrim(tmpSTR(UBound(tmpSTR)))    ' test = 1
Set MyRecSet = MyConn.Execute("DELETE * FROM table1 WHERE ID =" & "1")