470,593 Members | 2,411 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,593 developers. It's quick & easy.

Append Query

4 Nibble
Hello Experts,

Kindly provide guidance on how an append query with multiple criteria can be formed, this to append four fields data from Table A to Table B and Table B can have duplicates for 3 fields but one field has to be different. In the fields mentioned below the DocStatus will always different.

PrjectID MemberID MemberStatus DocStatus
2001 ABC UD JPP
2001 ABC UD JPA

Thanaks
TMatharu
Apr 1 '22 #1
1 5893
NeoPa
32,298 Expert Mod 16PB
Hi Sunny.

Let's start by explaining we're here to answer specific technical questions. That means you have to be clear about what you want and that what you want isn't composed of multiple questions.

This is unclear and contains the need to answer many questions and it's hard to know where to start because your question is vague about what you want help with.

I can say that if you want [DocStatus] to have only unique values in it then you should probably set the table up to ensure that.

An APPEND query is created by using the Query Wizard. That seems too simple for someone to ask that question so I guess what you are really asking for is still very unclear.
Apr 2 '22 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by John | last post: by
2 posts views Thread by JMCN | last post: by
1 post views Thread by David Barger | last post: by
2 posts views Thread by Ray Holtz | last post: by
4 posts views Thread by pmacdiddie | last post: by
1 post views Thread by hr833 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.