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...
ygoshy
Copper Contributor
I added table 1 to a design query and then added table 1 again and went to properties of the second table one and renamed it then saving it. Now I have all the exact fields as named in table 1. How do I get CNT into the renamed table without changing the original table 1 design? ;arnel_gp
arnel_gp
May 08, 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?
- ygoshyMay 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