Append Query

[TMatharu]

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

[NeoPa]

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.