Recent content by Geomg

  1. G

    Create 1 query from two data sets

    Not sure if I get sir. But there are not unique values since multiple IDs will have data in each of the products at a certain point. Meaning, We will have duplicated product names in each of the tables but some of them only available in each of the Data set. As example, Product #4 is only...
  2. G

    Create 1 query from two data sets

    In most of the cases, If the ID have data in the Product in one day from one of the data sets, it will also show data in the second table in the same product. That's the reason why ID 2 from 8/27 and ID 1 from 8/31 have assigned the data from both tables. But there are some cases where an ID...
  3. G

    Create 1 query from two data sets

    I am starting working with access and while I know a bit how it works, this new task I am planning to perform is not getting any desired results. Summary: The two main data sets have Users ID, Dates, and Product Name which I need to combine. Considering Product Names from Both data sets...
See more
Top Bottom