Union query unique values only in some field

[diegomarino]

hi,
i want to merge two queries using a union query; i want unique value but not for all the record, just some field must not match

FIELDS

NAME/SURNAME/POSITION/COMPANY/DATE




i want to merge every record from query 2 to query 1 but only records that have no match for NAME/SURNAME/POSITION/COMPANY field, the DATE field can be different

So if i have:

query 1
john wayne gunman westside 2/2/20

query 2
john wayne gunman westside 3/3/19


the record in query 2 (john wayne gunman westside 3/3/19) should not addedd in union query

thanks

[June7]

A UNION won't work that way. Different dates make records distinct. Why include date field?

Build the UNION then use it in an aggregate query to get Max([datefield]) or Min([datefield]) for each person.

So why do you even have two queries that need UNION? What is the source data?

[ssanfu]

If you really have fields names "Name" and "Date", you are asking for problems. "Name" and "Date" are reserved words in Access and shouldn't be used for object names.

Problem names and reserved words in Access

[diegomarino]

sorry they are not real names of my fields, i had to specify it

If you really have fields names "Name" and "Date", you are asking for problems. "Name" and "Date" are reserved words in Access and shouldn't be used for object names.

Problem names and reserved words in Access

[diegomarino]

my source data are linkedin exports, that i use a lot

so the problem is that i have two accounts and persons in both account, and i want to import just one of them; i export in the same time both accounts data, so some people are doubled but since i made the contact in different days the record will be the same for all field except the field "date", that's the date of connection

A UNION won't work that way. Different dates make records distinct. Why include date field?

Build the UNION then use it in an aggregate query to get Max([datefield]) or Min([datefield]) for each person.

So why do you even have two queries that need UNION? What is the source data?

[June7]

Did you try my suggestion?

[diegomarino]

yes i'm trying looks like is the good one.
i'm figuring out to make it with few steps cause i want to pack everything in my vba.
if i have not problems i just mark this as solved, thanks