Thanks for responding. No, it never worked in Access. The AccessDB shows each row (event) as a separate page. Some of the users hand-keyed the notes onto...

Thank you! I didn't know about UNBOUNDED AND PRECEDING.

Thanks again but I have a question about the second query with the WITH CTE: When I execute it I get a couple of errors. The first one...

Thanks very much drew.allen! This is what I needed.

This is absolutely not patient data (real names, real DOB, etc.). But as it appears that way I will delete it now that I have a solution. ...

Thanks ScottPlecther. Excellent. I remember that movie "Fatal Vision" and I can picture the Blackburn character saying that. I think it's been 30 year since I saw...

Thanks very much for your continued help. I'm getting an error on the line that says ) cj (service_type_cxd):

Msg 8158, level 16, state 1, line n

'cj' has more columns...

Thanks ScottPletcher, this answer is very useful for getting the values from the separate rows pivoted into one row with diastolic and systolic blood pressures. I realize that I...

I have been dreaming of working from home since 2002. No work place allows it because others (not in IT) would complain.My last job had one day a week...

Thanks John, that sounds like what I should do.

Thanks Jeff Moden and Jez. Jeff's answer was at times above my skill/experience level (CLR) but I still learned from it. Jez, I will follow your ideas to...

Thanks John Rowan, I'll use Kaj's answer. I appreciate the confirmation.

Thanks Kaj. This works for me.

Yes, sorry I didn't mention that but the truth is that i really would like the value in the base table to automatically update whenever the value in the joined...

Thanks drew.allen for your help. I need to update the joined table only once per month but it should be "triggered" when the table without the Boolean value is...