Has Anyone noticed the 3rd Quarter doesn't calculate in Northwind

  • Thread starter Thread starter gandydancer1952
  • Start date Start date
G

gandydancer1952

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.
 
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
 
Back
Top