• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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.
0
shelbyinfotech
Asked:
shelbyinfotech
1 Solution
 
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
 
shelbyinfotechAuthor Commented:
Got it figured out.

Needed to put "Expr1: True" in the 'field' section with NEWGRNBLT in the 'append to' section
0
 
Vee_ModCommented:
Closed, 125 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now