You can only get one year’s worth of data. So, you can’t select Oct 1 2000
through Dec 31 2001 That would be 14 months, and you JUST CAN’T do it. Calendar type
2 gets 13 months, no more.
You can't select values that are not calculated. E.g., if you use calendar-type 1, which
uses normal month-begin and end dates, you can't allow the user to select Nov 13 through
Nov 19. (You could, of course, do this in code, or you could pop up another calendar
control, or type in the dates manually, but MonthEnd will not be worth using.We're working
on a version that will allow you to select an end-date, and then go back one, two, three,
etc weeks). But for now, you have to use the values that are calculated.
If you DO try and do a Pivot table, where you group distributor number, warehouse, etc,
and then provide columns by month, (Col8Qty,Col9Qty,Col8Amt,Col9Amt) you can’t do it
with calendar-type 2 or 3 because Access pivots require that you translate the month into
a single value that can be calculated with the format function, like "Jan" or
"2001" or "Jan/01." Suffice it to say, you can’t pivot
("01/01/01 to 01/31/01, "02/01/01 to 02/28/01.") There are no RANGE options
in Access SQL. Calendar types 2 and three cross months and years, so, you can't get those
ranges.
If you're using SQL server, you can do Pivot tables between
two dates. See the tutorial or SQL Server for how to do
Cross Tabs for SQL server for any calendar type