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
- Thread starter HOMMER
- Start date
PaulBricker
Programmer
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
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
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
Similar threads
- Locked
- Question
