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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

compare two years

Status
Not open for further replies.

c123456rystal

Technical User
Sep 23, 2009
19
US
Hi, I have a data base and would like to compare data based on customer.
Say customer 1 sales for year 2005, 2006, 2007
Then next customer say same
 
Hi,
Create a Group on Customer and on Year
then list the sale records in the details..




[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Or you could insert a crosstab in the report header or report footer, with customer as the row, sale year as the column, and sum of sales as the summary.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top