Recent content by Acid1979

Found a solution but maybe you still have some ideas on how to do it better or more sophisticated: 1. I created a Query "AllCombinations" based on the Table "Products" the table "Period" (multiplying out all combinations of both tables). 2. I created a Query "MaxAllCombinations" based on the...

Dear Community, I created a table "Product" (simplified) with the following fields: "ProductName", "Amount", "lastUpdate". I was able to build a query showing me always the latest Record for each Product (based on the field "lastUpdate"). Now I would like to create a query showing me the...