kevinwilson
Technical User
hello all,
hoping someone can assist. the following statement grabs all fields and displays all the data, however i'd like the query to display only "active" records but i'm having difficulty with the "WHERE" clause. The fieldname is "Active" and is y/n type.
this works but retrieves all records, active and inactive.
strSQL = "SELECT " & strDBTable & "SysID.*" _
& " FROM " & strDBTable & "SysID " _
& " ORDER BY " & strDBTable & "SysID.SystemID "
in the statement below i'm trying to retrieve only active records where the "active" field is true...no success with this tho:
strSQL = "SELECT " & strDBTable & "SysID.*" _
& " FROM " & strDBTable & "SysID " _
& " WHERE " & strDBTable & "SysID.Active='"true'"
& " ORDER BY " & strDBTable & "SysID.SystemID "
Any help will be greatly appreciated.
Mahalo
hoping someone can assist. the following statement grabs all fields and displays all the data, however i'd like the query to display only "active" records but i'm having difficulty with the "WHERE" clause. The fieldname is "Active" and is y/n type.
this works but retrieves all records, active and inactive.
strSQL = "SELECT " & strDBTable & "SysID.*" _
& " FROM " & strDBTable & "SysID " _
& " ORDER BY " & strDBTable & "SysID.SystemID "
in the statement below i'm trying to retrieve only active records where the "active" field is true...no success with this tho:
strSQL = "SELECT " & strDBTable & "SysID.*" _
& " FROM " & strDBTable & "SysID " _
& " WHERE " & strDBTable & "SysID.Active='"true'"
& " ORDER BY " & strDBTable & "SysID.SystemID "
Any help will be greatly appreciated.
Mahalo