Currently I pull my dates using an expression to show like "Q1 2003". Which is doing as it is design to do? But it's pulling every 4 months a quarter.
How could I change to display every 6 months in a year as a quarter?
Here's what I got for 4 months;
ManagementQrt By Quarter: Format$([mytable].[datefield],'\Qq yyyy')
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!