Passing a variable to SQL

Newsgroups	comp.databases.ms-access
Date	2021-11-16 12:28 -0800
Message-ID	<411217df-e1c1-47a9-b09c-a79ef07f80dfn@googlegroups.com> (permalink)
Subject	Passing a variable to SQL
From	Ray Pearson <rwpearson123@gmail.com>

Show all headers | View raw

I have the following code -

 Dim varx As String
 
 varx = DLookup("[SubYear]", "[tblConfiguration]")
  
 Set db = CurrentDb()

    strSql = "SELECT FarNorth.JPID, FarNorth.FirstName, FarNorth.Surname, FarNorth.Email, FarNorth.Status, FarNorth.MOJNo, Sub2.SubID, Sub2.SubYear, Sub2.AmountPaid " & _
    "FROM FarNorth INNER JOIN Sub2 ON FarNorth.JPID = Sub2.SubID " & _
    "WHERE (((FarNorth.Status)='Active') AND ((Sub2.SubYear)= varx) AND ((Sub2.AmountPaid)Is Null) AND ((Len([FarNorth].[Email]))>0));"

What am I doing wrong?  varx is actually a  Year eg 2022.

TIAA - Ray

Back to comp.databases.ms-access | Previous | Next — Next in thread | Find similar

Thread

Passing a variable to SQL Ray Pearson <rwpearson123@gmail.com> - 2021-11-16 12:28 -0800
  Re: Passing a variable to SQL Ron Weiner <rw@domain.com> - 2021-11-16 17:17 -0500
  Re: Passing a variable to SQL Ron Paii <ron81pai@gmail.com> - 2021-11-18 09:22 -0800

csiph-web