I new at this, trying to keep writing code to a minimum.
I need to be able to generate queries and reports based on an accounting month (ie the month ends 3 business days before the last business day, assuming no holidays) in addition to queries/reports based on calendar month.
I created a dialogue box where the user can choose from a list of start and end "months" eg 1/01 to 5/01, and then click "Calendar" or "accounting". If accounting was chosen the report starts 12/26/00 and ends 5/28/01, inclusive.
Using format(date,MMM) in column grouping headings works fine in cross-tab queries with for the calendar report along with Jan, Feb etc in the Column headings.
I don't know what to do for the accounting months. Spent 25 hours on this already.
Is there a good (easy) way to have the MMM refer to a diferent set of days (calendar month)? Should I define a variable for each column heading?
Each year the months differ so I don't want to hard code anything. I'd love to have one set of reports, not 2.
I'm lost. Any ideas and/or directing me to samples would be terrific.
thanks
Brian
I need to be able to generate queries and reports based on an accounting month (ie the month ends 3 business days before the last business day, assuming no holidays) in addition to queries/reports based on calendar month.
I created a dialogue box where the user can choose from a list of start and end "months" eg 1/01 to 5/01, and then click "Calendar" or "accounting". If accounting was chosen the report starts 12/26/00 and ends 5/28/01, inclusive.
Using format(date,MMM) in column grouping headings works fine in cross-tab queries with for the calendar report along with Jan, Feb etc in the Column headings.
I don't know what to do for the accounting months. Spent 25 hours on this already.
Is there a good (easy) way to have the MMM refer to a diferent set of days (calendar month)? Should I define a variable for each column heading?
Each year the months differ so I don't want to hard code anything. I'd love to have one set of reports, not 2.
I'm lost. Any ideas and/or directing me to samples would be terrific.
thanks
Brian