I have a table with test results where different aspects were tested on different dates, each test having one of two outcomes. Each test has a date column and a result column.
Now I need a query which will combine the last result in each field in one line (row).
I do not seem to manage it with working with the "Totals" tool.
I attach the very small database to explain.
Please give advice. QueryProblem.mdb