Forum Discussion
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 wrong with the below to obtain my results?
10 Replies
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
- your first screen shot only show partial records from your table.
you archive your db to a .zip file then attach it here.
- it much easier to understand if we have any tangible table to work with.
if it is not much, can you upload the table.
