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