Search results

  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...
  16. W

    Question Import specific data cells from excel into Access 2016

    Hi Colin, It updated the data to the field, but it's incorrect. I need the corresponding data in the AR Transaction field to match according to the Company Number field. Also, some of the data updated are incorrect as there are duplicates, but if the entire column is empty, then it enters the...
  17. W

    Question Import specific data cells from excel into Access 2016

    Hello, I tried modifying my UPDATE query like how you had it, with the criteria I need, but when I run the query, it did not update any of the empty cell records. I attached a screenshot of my query
  18. W

    Question Import specific data cells from excel into Access 2016

    I applied the filter, but how do I know if it's pulling the correct set of records to be updated? When I tested to UPDATE button, it didn't do anything and when run the query, I got this error that I have attached. No, it would be a one-time update, but future references if this does happen...
  19. W

    Question Import specific data cells from excel into Access 2016

    I agree, long-term would be better to use the VBA code, but for now I think I will go with your idea of importing the table, update the data, and delete the imported table. Which way is better linking or importing the database? I attempted the import method, but need some assistance on creating...
  20. W

    Question Import specific data cells from excel into Access 2016

    If I use the automation code from the link you sent as reference, will it input the new data from Excel based on any empty cell, or will it go into the correct cell that it needs to be in matching the Company Number column? Since I have 30k records total and only about 9k needs to be updated...
Top Bottom