Report output does not match query

[kentwoodjean]

I have a table with fields that include:

Num Name: Format is name of company
Called #: (800 Telephone)
Call Date: (format 6/5/2002)
Call Time: (format 21:25:18:000)
State From: (format Ohio, Indiana etc)

Monthly, I transfer data from an Excel file to my Access Table, and have all the information from 1/1/2002 to 3/31/2003. My query contains the fields:

MySort: Month([Call Date])
Num Name: Name that applies to 800 #
Toll Free Number
State From
Month: Format([Call Date],"mmmm yyyy&quot
Call Time

The Query output looks like:

12 Jackson Life (800) 231-6532 MI December 2002 8:57:24:000

The report groups the total calls for each month/year by toll free telephone number. The problem is that it only shows the months jan 2002 - dec 2002. Why are the 2003 months not showing? I have no parameter for a specific year.

 

[Mike555]

Maybe the report has a filter on it.

Go to the report properties, data tab, and check the Filter and Filter On areas.

--
Mike

In defeat: unbeatable. In victory: unbearable. -- Winston Churchill

 

[kentwoodjean]

Checked to see if the filter is on and it is not. I think I may have figured out the problem but I am not sure how to correct it. I did have some help building this query some time ago, and to get the look I wanted in the report, I was told to set up the "MySort: Month([Call Date])" on my query in addition to the "Month: Format([Call Date],"mmmm yyyy&quot" field. The MySort is designated by the month #, beginning 1 through 12. This my sort is a non visable field on my report. Since all numbers, 1-12, have been used for 2002, I am assuming it will not allow me to reuse the numbers on the same report for 2003. Does that make sense?? How can I change "MySort" so I can use months in 2003 as well as 2002?

 

[dhookom]

After first reading your posting it seemed that January of 2002 might be grouped with January of 2003. You could try
MySort:Format([Call Date],"yyyymm&quot

Duane
MS Access MVP