I have a query that calculates Event start and end dates for people with living status changes. What I need to do is put them into columns showing first quarters for a year, then by year after that.
In the attached screen shot, the left side is already done in a query. The section in yellow is what I need to calculate. I was thinking of adding a query that would calculate each clients date range column, for example, for the first client there would be a column called 90Date which would contain dateadd("m",3,#1/7/2014#),
180Date column, etc. . The second client would have dateadd('m',3,#10/11/13#) and so on. Then use these calculated dates to calculate the number of days for each event. But I have a feeling there is a much easier way, I just don't see it right now.