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
ygoshy's avatar
ygoshy
Copper Contributor
May 03, 2022

Please review the attached sample of my Table. My previous screen shot shows all the fields within the actual data I have in my database. I made a copy of some fields to make a sample for your review. Table 1 shows the data that I made as a sample only. Theirs is over a million records in my database. My goal for the query is to come up with a result of the same "PCFN" and a different "Carrier" name. The result I am looking for is as shown in 'Copy of table 1".

 

Does this help?ygoshy 

 

UPDATE: I tried several time to upload the access database sample and keep getting the error message "

Please review the attached sample of my Table. My previous screen shot shows all the fields within the actual data I have in my database. I made a copy of some fields to make a sample for your review. Table 1 shows the data that I made as a sample only. Theirs is over a million records in my database. My goal for the query is to come up with a result of the same "PCFN" and a different "Carrier" name. The result I am looking for is as shown in 'Copy of table 1".

 

Does this help?ygoshy 

  • arnel_gp's avatar
    arnel_gp
    Iron 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

Resources