Forum Discussion
ygoshy
May 02, 2022Copper Contributor
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...
arnel_gp
May 07, 2022Steel Contributor
upload the db you have so i can see what you did.
do you believe i am poor in algebra especially on worded problem?
do you believe i am poor in algebra especially on worded problem?
ygoshy
May 08, 2022Copper Contributor
First, I do not mean to waste any ones time. My first example I only provided a small sample. Noe attached is a db with all fields in my accesss db with less than of 100 of the million within. I do not know it it makes a difference but I never use Primary Keys in my DB. The first 10 records are the ones I want in my query result. Note same PCFN # different carrier name. arnel_gp