User Profile
ygoshy
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Query for same PCFN and different Carrier
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_gp2.4KViews0likes0CommentsRe: Query for same PCFN and different Carrier
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_gp2.4KViews0likes2CommentsRe: Query for same PCFN and different Carrier
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 Tom2.5KViews0likes6CommentsRe: Query for same PCFN and different Carrier
Please reviewthe 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". Doesthis help?ygoshy UPDATE: I tried several time to upload the access database sample and keep getting the error message " Please reviewthe 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". Doesthis help?ygoshy2.5KViews0likes8CommentsQuery 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?2.5KViews0likes10CommentsRe: Query in access by linking
arnel_gpI am not a expert query writer and a little confused by your response. My table has many columns and almost a million rows in it. See below this is how I tried to do this query. The goal is the have a result where the PCFN is the same but the Carrier is different name. Will this additional information help your investigation to solve my issue?1.2KViews0likes0CommentsRe: Query in access by linking
George_HepworthI am trying to come up a query result from the same table that is as shown in the second example. This table has 50 or more columns and has almost a million rows. The second table is the same as the first one. It is a copy of it.1.2KViews0likes0CommentsQuery in access by linking
I have data the looks like the below. I want to create a query that will give me a result like the second one. I want all "PCFN" numbers that are the same but the "Carrier" is different as shown in second example below. I have tried to link the tables by PCFN # but do not know the criteriato enter in the Carrier column to get the results in the second table below. Thanks for any help provided. Tom Oct 2016 POD FIELD AND ADD DODAAC & PORTS Paid Date Carrier PCFN Invoice # 1/11/2021 MATSON NAVIGATION COMPANY, INC. 257899 8214855 6/7/2021 MATSON NAVIGATION COMPANY, INC. 269829 4952360 9/24/2021 MATSON NAVIGATION COMPANY, INC. 277917 4233331 12/13/2021 MATSON NAVIGATION COMPANY, INC. 284534 7532787 2/18/2022 PASHA HAWAII TRANSPORT LINES LLC 288045 MC174E288045 5/10/2021 SEALIFT INC OF DELAWARE 258876 258876 - 2020 12/27/2021 SEALIFT INC OF DELAWARE 265450 265450 - 21 10/21/2021 SEALIFT INC OF DELAWARE 271306 271306 - 21 Copy Of Oct 2016 POD FIELD AND ADD DODAAC & PORTS Paid Date Carrier PCFN Invoice # 12/27/2021 SEALIFT INC OF DELAWARE 265450 265450 - 21 12/27/2021 SEALIFT INC OF DELAWARE 265450 265450 - 21 12/27/2021 SEALIFT INC OF DELAWARE 265450 265450 - 21 12/27/2021 SEALIFT INC OF DELAWARE 265450 265450 - 21 12/27/2021 SEALIFT INC OF DELAWARE 265450 265450 - 21 12/27/2021 SEALIFT INC OF DELAWARE 265450 265450 - 21 3/24/2021 US OCEAN 265450 PC265450 3/24/2021 US OCEAN 265450 PC265450 3/24/2021 US OCEAN 265450 PC265450 3/24/2021 US OCEAN 265450 PC2654501.2KViews0likes4CommentsChange data from a row to a column
I have a column in access and/or excel as follows: ROW PCFN 1. 123456, 456789, 452123, 741852 or can remove commas between each number. 2. 987456, 521364, 796321, etc. I am trying to convert this column to: ROW PCFN 1. 123456 2. 456789 3. 452123 4. 741852 5. 987456 6. 521364 7. ETC. Can anyone help. I originally received this data in a excel worksheet with commas between each number. I can take out the commas if needed. I have also copied and pasted the column in a table in access. Thanks Tom1.2KViews0likes3Comments
Recent Blog Articles
No content to show