Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

year compairsion

Status
Not open for further replies.

HOMMER

Technical User
Apr 12, 2001
112
US
I want a report that will display the data this year and last year at the same time.
 
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

That should return records for 2002 and 2001.

Paul
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top