Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Breaking a monthly report by the Qtr
Message
De
10/10/2009 12:13:10
 
 
À
09/10/2009 21:27:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Vista
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01428608
Message ID:
01428649
Vues:
40
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform