Recent content by greid

I could get in trouble for just the sql I sent. I'll diagram it out.

So, how do I show you my database? Draw tables and relationships?

Problem is that this is for a report that goes to VP who'll never see my little access db and just want a short and comprehensive why. I need to demonstrate that these WOs do overlap and should not have their durations added up, but should span from 1 start date for the Project and 1 end date...

I'm able to calculate how long a Work Order (WO) took, and I can pull the First-FirstDate and Last-LastDate to get the total length of the Project, but how do I show the 11 day overlap between the two WOs? OK, not code, but I wanted the text to line up. PROJECT Work Order FirstDate...