Solved: Yes/No field

[Klartigue]

In access, I have a field named "Watching" and for this field i went added a yes/no check box for each account so I can check accounts that I am watching closely. Is there a query I can have to select only the accounts that are checked in the yes/no checkbox?


SELECT Accounts.[Account Number], Accounts.[Axys 8 Digit], [Account Name], [Secondary Description], [Investments], [Quality], [Taxable], [Composite], [Primary Description]
FROM Accounts
WHERE [composite]='municomp';

I know the query can look something like the above but when using a yes/no checkbox for the WHERE part..
WHERE[Watching]='???' I am not sure how to refer to accounts that are checked yes.


Thanks!

[Klartigue]

SELECT Accounts.[Account Number], Accounts.[Axys 8 Digit], [Account Name], [Secondary Description], [Investments], [Quality], [Taxable], [Composite], [Primary Description]
FROM Accounts
WHERE [watching]=yes;


Nevermind i figured it out!