I have 2 xlsx tables that are linked in Access. They both have the same field names but one is for sales and the other for canceled sales. I would like to create a query to append the data and remove duplicate account numbers for a total number of sales entered in all. I am reaching out for assistance for i have hit a brick wall.
Thanks.
I am not sure of what you are attempting. What data do you want to append and to what table? Perhaps you should post your db with dummy data so that no confidential information is shown and a better explanation of what specifically you wish to accomplish. Since your excel files are linked, you should post those also so that the links hold
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks