Many thanks, guys! Both seemed to work for what I needed. Appreciate the help!

lol, yes, this is not homework, and the dataset is actually a little more complex than what I presented. I dumbed it down a little to get to the...

Wouldn't the more accurate number be the difference between each test (diff test1 date and test2 date, test2 and test3, ... test9 and test10), totaled and divided by number of...

Because I need an average of number of days between all tests. Not just the previous. So if a student took 10 tests, I need the average of...

I've never used a dynamic pivot. Can you give an example?

Because my values can change each time I run it. Today there might be 9 quiz results, but tomorrow there might be 12. Just want to be able...

Kind of odd, that query returns 0 results.

No, the eventid is just a link between the production db and the datawarehouse.

Sorry for the confusion, guys. Let's see if this explains it better. I have come across an issue where a table logs conditions with

a timestamp, eventid and...

Here's the table structure:

event_id bigint (unique identifier)

userid ...

Click and drag on? The control seems to be static. The input parameters don't show in design view, so I can't view properties on the actual control.

Well, I've sort of determined part of the problem, and in turn, part of a solution, but I'm still running into a block.

My problem was that our product uses Forms...