Yes/No Values

[maintt]

Hi Guys

I have a form and on this form i have a field with a pre defined date, calculated by the DateAdd function, i have put a yes/no button next to the date field a i want to view/print a report that shows me which of the dates have not been ticked/checked, do i do this in query with the isnull function if so how?

Many thanks

Maintt

[jzwp11]

Yes, a query would be the best. Create the query in design view and include the fields you want. For the yes/no field, set its criteria=0. (Not checked=0, checked=-1). Base a report on the query you created.

Alternatively, you could not save the record until the yes/no box is checked. I think you would use the before insert event of the form to check to make sure the yes/no control is checked.

[maintt]

thanks jzwp11 i will give it a go and let you know i go on

maintt

[jzwp11]

You're welcome; please let us know if you are successful.