Recent content by wolves1

  1. W

    Pulling similar data from same table

    I have attached the files below the other replies.
  2. W

    Pulling similar data from same table

    Hello, I have attached the 2 sets of sample data. 1. The sample database containing all of the data (starting). 2. The expected results of the data the query would pull. To answer the other questions, there's no other suffixes only "I" or "F" is used for replacement items in the ControlNo...
  3. W

    Pulling similar data from same table

    Hello, I'm sort of new to creating Access queries and would like to see if I can get some help. I would like to know if it's possible to create a query to pull similar data sets from the same table or do I need to create a secondary query first. Below is my problem: The main table is called...
  4. W

    Mail Merge Many-to-One Relationships

    I tried to follow the NEXTIF command video I saw on YouTube. Not sure what version of Microsoft they could be using, so it seems like the version I have doesn't support it. Also, it looks pretty complicated as it's setting specific ID's to the data. This was the video I saw on YouTube for using...
  5. W

    Mail Merge Many-to-One Relationships

    I see, so even the use of NEXTIF commands won't really work? I saw something similar online, but it was adding products not different shops with addresses.
  6. W

    Mail Merge Many-to-One Relationships

    Hello, My apologies if my previous posts was confusing, but like referring to the first original post. The 3rd data for address, is the physical address of the shop. For Example: Letter Addressed to: Famous Donuts 1234 hello world New York, NY 65895 Letter Content lists any associated shop...
  7. W

    Mail Merge Many-to-One Relationships

    Hello, I have attached the sample data source excel file and an example of how the mail merge letter would look. Actual letter and data is different, but the idea is the same. If you look at the mail merge letter, I want to send one letter to the business recipient, "Famous Donuts", but in the...
  8. W

    Mail Merge Many-to-One Relationships

    II'm not sure what do you mean by petering out on the data content portion. If specifically the address you're looking for, then for example, parent shop (Famous Donuts) have an address of 1234 hello world. While the related shop name (Ice Cream) could have an address of a PO Box 23648. On the...
  9. W

    Mail Merge Many-to-One Relationships

    Hello, I'm rather new with creating mail merge letters. Requesting some help on creating a mail merge letter for one-to-many relationships. Replaced names for privacy for the scenario: Data Headers: 1. Shop Name 2. Related Shop Name (2nd store, but different shop name, but under same owner of...
  10. W

    Question Import specific data cells from excel into Access 2016

    HI Colin, Thanks for the heads up. I'll check with the staff to make sure everything is correct as it seems like information doesn't get translated right away... Thanks, Carmen
  11. W

    Question Import specific data cells from excel into Access 2016

    Actual table because the Notice Number is only unique based on the year. The same number can show "x" amount of times as long it is on different years. There shouldn't be two exact Notice Numbers in the same year. For example, in 2014 there should only be one "0001" Notice number. Then in 2015...
  12. W

    Question Import specific data cells from excel into Access 2016

    Hi Colin, So I attempted to join the Year column together and it worked. I guess crises averted! Thanks again, Carmen
  13. W

    Question Import specific data cells from excel into Access 2016

    Hi Colin, Turns out after speaking with a staff, they forgot to tell me a key detail when updating the data to the empty cells. The primary key was not the Company number, but instead a different column called Notice Number. This Notice Number column's numbers are unique based on a different...
  14. W

    Question Import specific data cells from excel into Access 2016

    Hi Colin, Testing a small batch with the actual DB, but when I run the query, it said it's going to update 23 rows instead of my batch of 9. I have a feeling it might create duplicate incorrect data like the first time when I tried on test data. Any advice? Thanks, Carmen
  15. W

    Question Import specific data cells from excel into Access 2016

    Hi Colin, Just an update to my previous post, I tried running the query again by removing the previous uploaded data to see if it does the same thing and it's now working fine. Data is entered correctly matching the Company Number and no duplicate data was made. I will try again with a larger...
Top Bottom