Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Breaking a monthly report by the Qtr
Message
From
10/10/2009 12:13:10
 
 
To
09/10/2009 21:27:59
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Vista
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01428608
Message ID:
01428649
Views:
41
Randy,

select from myTable where mod(month(reptmonth),3)=0 into curReport
should give you the results for sept,oct,nov,dec

change 3 to 4 to get results for oct,nov,dec

However i like Sergey's solution better, make use of the Quarter() function, which I believe is also available in VFP7


Regards,

Koen
Previous
Reply
Map
View

Click here to load this message in the networking platform