That is a little vague to give you a specific response. If the info is in a query then you could try this.
In a new column of your query put
MyYear:Year([DateFieldname])
Then on the criteria line for this field put
Between Year(Date()) And Year(Date())-1
Hi,
If you want to separate the data, and show it in different columns as my example shows, then you will want a crosstab report.
SALES REPORT for 2001-2002
Jan'01 Feb'01 Mar'01 Apr'01 ......... Jan'02 Feb'02
5,000 6,000 3,500 2,500
### #,### #,### #,### ......etc.
In case this is what you need, I wrote a FAQ on how to understand the three key elements needed in a crosstab report query. Here is the link to that info: faq703-2868 HTH,
Randy Smith
California Teachers Association
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.