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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Marshall2000
- Order by date
-
How to compare data by month
Thanks for the help Paul. It works perfectly and my data is formatted just the way I wanted it. Marshall- Marshall2000
- Post #7
- Forum: Microsoft: Access Reports
-
How to compare data by month
Sorry but that didn't work. I still have the month showing twice. The first time shows 2002 data in the h1 fields and the second pass shows the 2003 data in the cy fields as shown. Month hiamount cyamount h1count cycount January 1000.00 1200.00 February 1233.00...- Marshall2000
- Post #5
- Forum: Microsoft: Access Reports
-
How to compare data by month
SELECT [All retail by year].account, [All retail by year].name, [All retail by year].date, [All retail by year].CYamount, [All retail by year].CYstatunits, [All retail by year].CYCount, [All retail by year].H1amount, [All retail by year].H1statunits, [All retail by year].H1Count FROM [All retail...- Marshall2000
- Post #3
- Forum: Microsoft: Access Reports
-
How to compare data by month
I am attempting to create a report that compares data from 2002 to 2003 by month. I have a query that has the 2002 data with field names h1amount, h1count. it also has 2003 data in fieds cyamount and cycount. I want to compare the data side by side by month. Example Month hiamount...- Marshall2000
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
