Using Memory viarable

[Song Su]

I have following:

Dim mYYYY as String, mSem as String
mYYYY="2007"
mSem="3"

How to fix following line to use mYYYY and mSem? I am confused with
single/double quote.

dbs.Execute "DELETE * FROM " & _
"Transcript WHERE yyyy = '2007' and sem = '3';"

 

[Dirk Goldgar]

I have following:

Dim mYYYY as String, mSem as String
mYYYY="2007"
mSem="3"

How to fix following line to use mYYYY and mSem? I am confused with
single/double quote.

dbs.Execute "DELETE * FROM " & _
"Transcript WHERE yyyy = '2007' and sem = '3';"

Try:

dbs.Execute _
"DELETE * FROM Transcript " & _
"WHERE yyyy = '" & mYYYY & "' and sem = '" & mSem & "';"

 

[Song Su]

Works great! Thanks.

Try:

dbs.Execute _
"DELETE * FROM Transcript " & _
"WHERE yyyy = '" & mYYYY & "' and sem = '" & mSem & "';"


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[John W. Vinson]

I have following:

Dim mYYYY as String, mSem as String
mYYYY="2007"
mSem="3"

How to fix following line to use mYYYY and mSem? I am confused with
single/double quote.

dbs.Execute "DELETE * FROM " & _
"Transcript WHERE yyyy = '2007' and sem = '3';"

Concatenate the values of the fields into the string, along with the
singlequote delimiters:

dbs.Execute "DELETE * FROM Transcript WHERE yyyy = '" & mYYYY & "' AND sem =
'" & mSem & "';"


John W. Vinson [MVP]

 

[Marshall Barton]

I have following:

Dim mYYYY as String, mSem as String
mYYYY="2007"
mSem="3"

How to fix following line to use mYYYY and mSem? I am confused with
single/double quote.

dbs.Execute "DELETE * FROM " & _
"Transcript WHERE yyyy = '2007' and sem = '3';"

dbs.Execute "DELETE * FROM Transcript " & _
"WHERE yyyy = '" & mYYYY & "' And sem = '" & mSem & "' "