View Single Post
  #1  
Old December 16th, 2009, 02:01 PM posted to microsoft.public.access.gettingstarted
Coco111 via AccessMonster.com
external usenet poster
 
Posts: 32
Default Help in Sales Analysis - Northwind template

Anybody Please help... Sorry again, in Northwind template 2007. I found
something wrong in sales Analysis, but I dont know how to solve.

Queries of sales analysis show below-

MonthOfQuarter: (Month([Order Date]) Mod 3), in data sheet view oct = 1, Nov
= 2, Dec = 0 and sales of Dec did not show up. I guess Dec should be 3, if
im not wrong. What do you think and how to solve the problem. The sales of
dec month did not show up...it shows no sales or 0 in quarter sales report
summary. Thank you.

--
Message posted via http://www.accessmonster.com