Concatenate with a value of TRUE

[gmazza via AccessMonster.com]

Hey there,
I am trying to concatenate a recordset as follows:
Set rs = CurrentDb.OpenRecordset("Select * from InclusionCriteria where
ClinicalTrialId = '" & study & "'" & " and Inactive = '" & True & "'")

It works without the last part:
& " and Inactive = '" & True & "'")

The Inactive field in my table is a Yes/No field so I just want the records
where Inactive = True.
What syntax am I getting wrong here?
Thanks in advance!

 

[fredg]

Hey there,
I am trying to concatenate a recordset as follows:
Set rs = CurrentDb.OpenRecordset("Select * from InclusionCriteria where
ClinicalTrialId = '" & study & "'" & " and Inactive = '" & True & "'")

It works without the last part:
& " and Inactive = '" & True & "'")

The Inactive field in my table is a Yes/No field so I just want the records
where Inactive = True.
What syntax am I getting wrong here?
Thanks in advance!

True is an Access constant (it's value is -1). Therefore, as a Number
value it should NOT be placed within single quotes, i.e. 'true'.

Where ClinicalTrialId = '" & study & "' and Inactive = True")
is all you need.

 

[smartin]

Hey there,
I am trying to concatenate a recordset as follows:
Set rs = CurrentDb.OpenRecordset("Select * from InclusionCriteria where
ClinicalTrialId = '" & study & "'" & " and Inactive = '" & True & "'")

It works without the last part:
& " and Inactive = '" & True & "'")

The Inactive field in my table is a Yes/No field so I just want the records
where Inactive = True.
What syntax am I getting wrong here?
Thanks in advance!

True is a boolean value, not a string:

....ClinicalTrialId = '" & study & "'" & " and Inactive = True"

 

[gmazza via AccessMonster.com]

Thanks fredg!

Hey there,
I am trying to concatenate a recordset as follows:

[quoted text clipped - 8 lines]

What syntax am I getting wrong here?
Thanks in advance!

True is an Access constant (it's value is -1). Therefore, as a Number
value it should NOT be placed within single quotes, i.e. 'true'.

Where ClinicalTrialId = '" & study & "' and Inactive = True")
is all you need.