Append Query to Boolean Column with Criteria

I'm trying to create an append query to a blank table "Checklist".  
Column Checklist.NEWGRNBLT is boolean.
I'd like to append to NEWGRNBLT if (Table1.VAL14 <>0) and I'm having trouble doing this in query design.
shelbyinfotechAsked:
Who is Participating?
 
shelbyinfotechAuthor Commented:
Got it figured out.

Needed to put "Expr1: True" in the 'field' section with NEWGRNBLT in the 'append to' section
0
 
Sham HaqueSenior SAP CRM ConsultantCommented:
try:
<> False
0
 
peter57rCommented:
I can't quite imagine what trouble you are having.
You just need to specify <>0 in the criteria cell for column Val14.
0
 
shelbyinfotechAuthor Commented:
I guess I'm not explaining it well.

I want to append to the column NEWGRNBELT the value of "TRUE" if VAL14 <> 0
0
 
Vee_ModCommented:
Closed, 125 points refunded.
Vee_Mod
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.