Forum Discussion

ygoshy's avatar
ygoshy
Copper Contributor
May 02, 2022

Query for same PCFN and different Carrier

See below. I am trying to write a query that the "PCFN" is the same that only includes a different "Carrier" name.  I keep getting that something like ( , etc is wrong. Can anyone look at what is wro...
access
arnel_gp's avatar
arnel_gp
Steel Contributor
May 03, 2022
your first screen shot only show partial records from your table.
you archive your db to a .zip file then attach it here.
ygoshy's avatar
ygoshy
Copper Contributor
May 04, 2022

arnel_gp  I have saved the access information to a excel database. Sheet 2 is the results I need to be. Sheet 3 is the data of various records it is derived from. Can you import into access to help in getting my desired results?

 

Thanks Tom

    • ygoshy's avatar
      ygoshy
      Copper Contributor
      May 06, 2022
      I am confused. Where is table "T" located in the linked query? Did you make it?
      • arnel_gp's avatar
        arnel_gp
        Steel Contributor
        May 07, 2022
        if you open Query1 in SQL view, you will see that T is just an Alias for the sub-query.

Resources