creating update queries (1 Viewer)

[smitheroosky]

This should be an easy one for you. I'm tyring to make an update query, however when I click on the arrow next to the query type button it is just an empty box and I cannot select update. I've got another update query in this database, but I can't remember how I made it. Any help would be appreciated. Thanks

 

[smitheroosky]

OK, I solved that problem. I do have another question though. Can I use an absolute value function in the update query with a field name as long as the field only has numbers? For example, this is one of the attempts I typed into the update to row:

Abs[Oral Communication]

Or, if there is a way to store a checkbox as 0,1 (for not checked, checked) instead of 0,-1 that would work as well. Thanks.

 

[Alexandre]

Yes.
In the first line a new column in the QBE grid, write something like:
AbsValue: Abs([Oral Communication])

BTW you should avoid using spaces in your filed names