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

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.
 
J

John Spencer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where are Mod's defined in databases 1
Printing Each Month in a Quarter on a Separate Line 5
Calculate in a Crosstab? 4
Pivot table headache 2
Change in table does not update existing records 1
Calculating commission schedule (will pay for help!) 2
Excel question, will pay for answer, calculating commission schedu 1
Trying To Convert Some Code Given To Me In A Previous Answer * HEL 1

Top