I suggest making a copy of your check box formatted field, changing the copy's format back to Edit box and then placing it next to the original copy of the field. Then try clicking different check boxes and in different orders while watching the edit box copy to see what data is actually being added or deleted from the field. It can be a major eye opener.
Use FilterValues to determine if a particular check box has been selected or not in your field:
IF [ Not IsEmpty ( FIlterValues ( YourTable::project_needs ; "video" ) ) // video box is checked ]
the functions I have used may be looked up in FileMaker Help if they are unfamiliar.
PhilModjunk, Thank you. You are right. Changing the check box to edit box shows how each value can be list in different orders. Thanks for the tip.
The IF statement worked wonderfully thanks.