user14867 Member

Thank you for the example and details. Unfortunately, I'm having trouble with getting this to function as described. Depending on how I tweak, I either get too few or way too many records. As per your note "This is assuming you have one record per date otherwise you'll get duplicate records," I do have multiple records per…

Also can you clarify "join the table twice"? Thanks in advance

Nice! I appreciate the creative solution, thank you.

Thanks, this looks like it will do the trick!