Fritz Paul
asked on
How to write a query which puts last test results of different fields in one line
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the compliment.
I do have lots of experience with SQL, but truth-be-told, the real trick is getting it to work in Access which is overly fussy about parenthesis.
I do have lots of experience with SQL, but truth-be-told, the real trick is getting it to work in Access which is overly fussy about parenthesis.
ASKER
Does that come from an excellent knowledge of SQL or what am I missing?
Should I just study SQL?