• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Question on MS Query in Excel

C

cmkarnes

Member
Hi, I have an Excel workbook project I'm working on at the office. There are two separate worksheets within the workbook. These two worksheets need to remain separate. For one of the worksheets I set up a connection pulling in data from an Access database using the MS Query wizard. Everything for that worksheet is working perfectly. I've set up another MS Query for the 2nd worksheet (tapping into the same database), and that works too, but it is bringing in duplicates of each item. I set up separate queries for each sheet. The query fields are nearly identical but for 2 extra fields for the 2nd sheet. I don't know enough about SQL to understand why I am getting duplicates. I've looked at the Command Text and nothing really stood out to me that looked odd.

Can someone out there tell me what the problem might be or what steps I need to take to rectify this? I'm thinking it is probably something simple that an expert would understand better than I. I'm not sure where to start on this issue. Thank you so much. Chris
 
Hi Chris ,

If you can upload your workbook with the SQL and the results in it , it should be easier , and you may get your answer faster.

Narayan
 
Hi, sorry for the delay in replying. I just returned to the office yesterday, looked at it again, and figured out it had to do with the Access data being pulled in, and was able to fix it and now it works correctly. Thank you though for replying. Chris
 
You must log in or register to reply here.
Back
Top