UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Append Query Criteria Failure, Access 2016    
 
   
alexaralvarado
post Sep 12 2017, 09:30 PM
Post#1



Posts: 1
Joined: 12-September 17



Greetings.
I'm trying to create a query that would append data from a field (let's say a text field called fName) in table A to table B, but I want to make it so that only copies "fName" registries from table A if a Yes/no field (let's call it fRequires) from table A is turned on, marked or selected.

Attached File  tab_a.png ( 5.07K )Number of downloads: 0
Attached File  tab_b.png ( 3.33K )Number of downloads: 0

Example: In table A only for Alex and Jesus is fRequires checked so what I want with the query is end up with only their names in table B.

I've been told that this can be done by declaring a criteria that checks if fRequires = "yes" but it keeps giving a wrong value message error if I try to run the query.

Any help will be deeply appreciated
Go to the top of the page
 
MadPiet
post Sep 12 2017, 09:35 PM
Post#2



Posts: 2,221
Joined: 27-February 09



Yes is -1 in Access. So you'd build your select query first (use the QBE grid), then turn it into an append query once it's returning the values you want.
Go to the top of the page
 
projecttoday
post Sep 12 2017, 10:13 PM
Post#3


UtterAccess VIP
Posts: 8,593
Joined: 10-February 04
From: South Charleston, WV


welcome2UA.gif

--------------------
Robert Crouser

My company's website
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th November 2017 - 07:24 AM