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 wro...
I am confused. Where is table "T" located in the linked query? Did you make it?
if you open Query1 in SQL view, you will see that T is just an Alias for the sub-query.
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
- upload the db you have so i can see what you did.
do you believe i am poor in algebra especially on worded problem?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