Forum Discussion
Query in access by linking
I have data the looks like the below. I want to create a query that will give me a result like the second one. I want all "PCFN" numbers that are the same but the "Carrier" is different as shown in s...
Is this a table? What is the name of the table?
There are values in the second copy that do not appear in the first copy of the table. Where do they come from?
In the second copy there are multiple rows that appear to be identical. Why?
In trouble-shooting problems like this context and detail are really important to conveying the situation to others who can't see the source, and have no idea what the purpose or goal is. Help us by providing that context and detail. Thank you.
George_Hepworth I am trying to come up a query result from the same table that is as shown in the second example. This table has 50 or more columns and has almost a million rows. The second table is the same as the first one. It is a copy of it.