Update option group field

[mraetrudeaujr]

I'm trying to update a new field (option group generated) from a "check box" field. I thought that an SQL statement would work best, but I'm not that good at building one from scratch. The following is my attempt at it:
Table name = 2005 LOG
New field name (option group) = TempFileUsed
Old field name (check box) = TempFileUsed1

UPDATE [2005 LOG].[TempFileUsed]
SET TempFileUsed = 1,
WHERE TempFileUsed1 = 'TRUE';
FROM [2005 LOG]

I'm sure that something is missing, but at least I'm taking a stab at it, right? Thanks for the help everybody.

 

[mraetrudeaujr]

I went back and searched the Forum archives and found something that I could modify:

UPDATE [2005 LOG] SET TempFileUsed = IIf([TempFileUsed1],TRUE, Null)
WHERE TempFileUsed Is Null;

This looks like it worked (over 7300 records!) but it put minus signs in front of the numbers? How do I get rid of those?