Search results

Sorry i understand now. 1) There is a chance that a month won't be represented by a Finish_Date/Baseline_Finish 2) The data is an extract from MS Project and at source some values are recorded as "NA". There will only every be a date or "NA" however.

Thanks Plog! So I'm a little stuck with the third query I need to create. SQL queries are new to me and I'm not too sure how I would write it. The data would never have a blank, but the Baseline_Finish column may show "NA" rather than a date - is that a problem?

Apologies for the table, hopefully the below looks better: Unique_ID;Finish_Date;Baseline_Finish 1;01/11/2012;01/11/2012 2;30/11/2012;30/11/2012 3;05/12/2012;29/11/2012 4;07/12/2012;17/11/2012 5;23/11/2012;23/11/2012 6;01/01/2013;18/12/2012 7;18/01/2013;18/01/2013 8;18/12/2012;18/12/2012...

Hi, I'm looking for the right way to set up a query to give me a cumulative count of items, over time, to populate a comparative line chart. My table has a number of other columns, but I'm pretty sure the ones I need for this query are as below...