Querying Access

[nipchop]

Hi,

I've created a database and I am trying to query the table from a form. I want to see if a field IsNotNull if a chkbox is ticked.

In the query I have tried a number of variations including

[Forms]![frmSearch]![chkBOMREV=IsNotNull]
[Forms]![frmSearch]![chkBOMREV="IsNotNull"]
[Forms]![frmSearch]![chkBOMREV=(IsNotNull)]

but none appear to work...can anyone help?

 

[FuzzyBear9]

Hi,

Assuming you are making your query using SQL, then:

SELECT Table1.Name, Table1.[Active?]
FROM Table1
WHERE (((Table1.[Active?])=Yes));

Where you have a table named: Table1
With fields:

ID AutoNumber
Name Text
Active? Yes/No

Specifying 'Yes' or 'No' will determine whether records with the field ticked (Yes) or not ticked (No) are returned.

 

[nipchop]

Cheers

Is see that would work but the field I am looking at is a text based field.

Tim