Recent content by lukets123

Thank you very much!

No need to leave it running all night, you already helped me a lot In Excel and Access I'm letting it run for hours but I don't finish it, but now the reason is explained, I need 6 days to update all the information. Anyway thank you very much, I will divide the database into smaller parts to...

My database is huge. I send for you the real version to check, i'm trying to running this Module but not running. Follow the link to download the database: we.tl/t-ZjolYcJH6J

@MajP You must store, if the result is 11, 12, 13, 14 or 15, separating them into 5 new columns. I redid the calculation in a simpler way in a new excel, and we really don't have any combination that has 14 equal values between the tables and we only have 1 time that the 15 numbers are...

@MajP I will continue considering ID 1 for the explanation, but the rule is the same for everyone. The formula takes the sequence of ID 1 (Results), and verifies how many values are equal in the Base table (ID 1), if we compare both lines we will have that 11 values are equal, being: 2 3 5 6...

Good Morning. Please, I need to perform a matrix count within Access, I am leaving attached the model of my tables in Excel. I need to convert my Excel formulas into Access. Formulas are in columns Q, R, S, T and U of the "Result" tab Below is the link to download the Excel model and tables...