dwain.c (4/26/2012)

For the third question, where you say MTD is BETWEEN start date AND end date. A sensible MTD would require that start date then be the first date...

dwain.c to answer you questions:

1. Unfortunately that is not the case, but I do have access to an AccountingCalendar table, which I will discuss shortly.

2. Correct

3. MTD...

As a side note, the forecast values for a given class typically won't fluctuate much week to week within a given month. My understanding from our sales folks is...

Thanks Steve and dwain.c for the help and I apologize for all the improper formatting.

I'll get right to the point and try to answer your questions Steve (in order)

FirstDay is...

OK, like I said I'm a newbie, so here's my 2nd attempt:

I have to create a report that compares actuals vs Forecast at 3 date intervals grouped by Item...