Merge 3 Fields - CLOSED

Would you please give us some EXAMPLE DATA so we can more clearly understand what you want. Show and sample of your INPUT data and then a sample of your OUTPUT data.

Sorry, but I still cannot understand from your 2 screenshots exactly what you want. (The items in your ThreeFields sceenshot do not seem to match those in your Results screenshot.)

…Group and count…

You obviously have been able to do the THREE (3) INDEPENDENT queries to GROUP and COUNT the data in each of your 3 tables (where is the example for this?), and then you want to MERGE them – but I am not clear what the basis of the MERGE actually is. I think you need to provide a clearer example to show how you want your OUTPUT to look and how it related to the example 3 queries inputs.

Despite looking at your SAMPLE .ods file, I’m not sure if I understand what you want. Are you saying you just want to combine the first 3 lists (AGENTEUM, AGENTEDOIS, AGENTETRES) to make one big alpha-SORTED list (without removing repeated entries)? If so, it seems overkill to use Base to do this job.

By the way, I assume your main database is a Base .odb file – are you able to post a SAMPLE file to show how you have setup your form/s, queries.

Please give us some more feedback so we’re on the right track.

SELECT
    AGENTS,
    COUNT(AGENTS) "Cont.Núm - AGENTS"
FROM
    (SELECT ID, "AGENTEUM" AGENTS FROM "TABLE"
        UNION
    SELECT ID,"AGENTEDOIS" FROM "TABLE"
      UNION
    SELECT ID,"AGENTETRES" FROM "TABLE")
GROUP BY
    AGENTS
ORDER BY
    AGENTS

See attachment
R