This is a discussion on Crosstab query - daily progress tracking within the Microsoft Access forums, part of the Question Forums category; Dear all, I need a query to that will enable me to track the progress of my product testing. I ...
Dear all, I need a query to that will enable me to track the progress of my product testing. I have a table of test logs, each marked with dates and different categories, and I need to monitor the progress on a daily basis. My problem is to design a query that for a given date, say “today-n”, can extract the latest test log older that than this date, and do this for all n’s down to n=0.
I guess I need a crosstab query and have tried different combinations of MAX() and BETWEEN, but can’t get it to work, hope you can help me.
Thanks in advance