checkboxes

[Lauren J. Bradford]

I have a series of "milestones" that become checked as certain events occur
in contract negotiation. I would like to create a query that allows me to
search by furthest box checked. (I.E. search for all clients that have
returned a signed contract--query would find all clients with that box
checked, but no further).

Any assistance would be greatly appreciated.

Thank you,
Lauren

 

[Guest]

for just 1 milestone it would look like

SELECT [contract].*
FROM [contract]
WHERE ((([contract].signed)=True));

In order to choose any milestone you can write a sql query for each
milestone that can be very time consuming with many milestones. With many
milestones what you are looking to do is replace the where clause field
signed with what ever the different milestones are depending on what you
want. Right? For that you will need to write your sql query in vba. Take a
look at this.

http://www.fontstuff.com/access/acctut15.htm

HTH
Martin J