Hi
In the query designer grid, take the checkbox column (chkEEOwned) and make it a claculated column ie put Owner:=IIF([chkEEOwned,"Employee Owned","Company Owned"
Hope this helps Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK