wmix's latest activity

  • W
    wmix replied to the thread Solved Duplicate Items in Query.
    I found the issue. I had to change from a LEFT JOIN to an INNER-JOIN Didn't Work: FROM qProductsSold_Candy LEFT JOIN tblVendPricesCandy...
  • W
    wmix reacted to jdraw's post in the thread Solved Duplicate Items in Query with Like Like.
    wmix, If you provide the table structures/designs including indexes, and the SQL for the query(ies) involved, I'm sure you'll get...
  • W
    wmix reacted to plog's post in the thread Solved Duplicate Items in Query with Like Like.
    The key to these types of problems is to focus on 1 specific instance and drill down on it. Don't get overwhelemed thinking you have...
  • W
    wmix reacted to Isaac's post in the thread Solved Duplicate Items in Query with Like Like.
    Access does make it extra easy by allowing you to physically open tables and filter them. Although beware of the right-click and Filter...
  • W
    wmix replied to the thread Solved Duplicate Items in Query.
    Thanks jdraw. The unique identifier is the ProductInOutID. Here's the SQL of the query: SELECT qProductsSold_Candy.ProductInOutID...
  • W
    wmix posted the thread Solved Duplicate Items in Query in Queries.
    Hello Everyone, I'm struggling with duplicate items in a query and completely stumped as to why it's happening. I have walked away from...
Show older items
Top Bottom