Select Statement (from earlier post)

[DJ]

Attempting to get this syntax correct:
Alex sent an earlier reply, but it produced an error
also. Would someone else take a look at this.
Thanks

strSQL = "SELECT count(*) As MyCount FROM Registration
where Field48 = " & Me.Barcode_Number And "Field49 = '" &
IR & " '"

I am attempting to use the two pieces of info on a form
(1) a integer field on a form and (2) a string value on
the form. But, this damn syntax is killing me. Can
someone help in getting this statement syntax correct.
Would appreciate it.

 

[Alex Dybenko]

if Me.Barcode_Number - number and IR (prpbably me.IR) - string then:

strSQL = "SELECT count(*) As MyCount FROM Registration where Field48 = " &
Me.Barcode_Number & " And Field49 = """" & IR & """"

 

[Alex Dybenko]

"""" is 4 times "

if Me.Barcode_Number - number and IR (prpbably me.IR) - string then:

strSQL = "SELECT count(*) As MyCount FROM Registration where Field48 = " &
Me.Barcode_Number & " And Field49 = """" & IR & """"

 

[TC]

Change:

.... & Me.Barcode_Number And "Field49 = ...

to:

.... & Me.Barcode_Number & " And Field49 = ...

Note the space after the "

HTH,
TC