Set a criteria in a query for a checkbox?

[OverDrive]

How do I set a criteria in a query for a checkbox>?

I have tried "true" and "-1" but that is not working?

I should also mention that I have other fields with criteria in them as well... if it matters or not I am not sure?

Thanks
Chance~

 

[LNBruno]

Specify the value of the checkbox:

chkEdited.Value = True

< M!ke >

 

[OverDrive]

I place that in the criteria and it throws out an error?

 

[LNBruno]

If you post your query, it would help know where/how to implement...

< M!ke >

 

[OverDrive]

SELECT [tblMain].[DispositionStatus], [tblMain].[IndictmentDate], [tblMain].[FirstName], [tblMain].[LastName], [tblMain].[AUSAAssigned], [tblMain].[IndictmentNumber], [tblMain].[DispositionDate], [tblMain].[IndictedYes]
FROM tblMain
WHERE ((([tblMain].[DispositionStatus])=&quot;IN&quot)
ORDER BY [tblMain].[IndictmentDate];

 

[OverDrive]

&quot;IndictedYes&quot; is the checkbox field I am trying to get to set a criteria to &quot;True&quot;

 

[LNBruno]

I must not understand what you're trying to do; I don't see a reference to where you're trying to set a checkbox criteria in this query?

< M!ke >

 

[OverDrive]

Hows This....

SELECT tblMain.DispositionStatus, tblMain.IndictmentDate, tblMain.FirstName, tblMain.LastName, tblMain.AUSAAssigned, tblMain.IndictmentNumber, tblMain.DispositionDate, tblMain.IndictedYes
FROM tblMain
WHERE (((tblMain.DispositionStatus)=&quot;IN&quot AND ((tblMain.IndictedYes)=&quot;Ture&quot)
ORDER BY tblMain.IndictmentDate;

 

[OverDrive]

I meant to place &quot;True&quot; in that criteria not &quot;Ture&quot;

It still does the same thing with &quot;True&quot;

THANKS!
Chance~

 

[LNBruno]

Ah, ok. Try replacing TRUE w/ -1?

< M!ke >

 

[OverDrive]

Actually, someone mentioned to me that boolen needs to be &quot;without quotes&quot;

I tried it without the quotes and it worked!

Thanks!!
Chance~

 

[LNBruno]

Hey, great! Now we both can get some sleep tonight! LOL!

< M!ke >