Prev: Conditional Formatting on client
Next: Open 5 combined Reports
From: gandydancer1952 on 15 Mar 2010 19:55
Using Northwind to set up quarterly reports in my db. The MonthOfQuarter:
(Month([Inbound Date]) Mod 3) Separates the months quarters into 1,2,0 but
the VB Code is set up for 1,2,3. The third month in any quarter shows a
quantity of 0 for all Customers when there are numbers there to calculate.
From: John Spencer on 16 Mar 2010 09:16
Try using this expression to calculate the month number of the period
((Month([Inbound Date])-1) Mod 3) + 1

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

gandydancer1952 wrote:
> Using Northwind to set up quarterly reports in my db. The MonthOfQuarter:
> (Month([Inbound Date]) Mod 3) Separates the months quarters into 1,2,0 but
> the VB Code is set up for 1,2,3. The third month in any quarter shows a
> quantity of 0 for all Customers when there are numbers there to calculate.
 | 
Pages: 1
Prev: Conditional Formatting on client
Next: Open 5 combined Reports