I want to run a query for the monthly data. The table only supplies me the
date (no month). Our Accounting Month does not work along with the
Calendar
Month, for instance, July 2008 starts with 29th June and ends with 2nd
August
2008.
I can make the month either with PLUS day or MINUS day for the month
across
with 2 months. which does not include the dates of 3 months :
I have a criteria for pop up parameter value for the user to input the
month, e.g. July,
then I made in the "field" with another parameter pops up to fill out 1
(i.e. plus 1 day). It works out fine to have June included.
Since this July includes the 1st 2 days in August, I don't know whether
it's
poslsible to combine the "minus" in the following function :
AcctgMonth: Format$([Date]+[Enter Plus days betw MEC and cal-month, if no
diff, enter 0],'mmmm')
Please help.
thanks
Karen
|
