Hi,

I am trying to write a report that will look up information through a query. Almost every column will need to be queried by month and year. Here is the lay out:

Cust Name (Option for one or range)/Item code/Desc/ Qty Shipped by Current Mo and Yr. / Order Status by Mo & Year/ Total balance to be shipped (Formula of first two) / Qty shipped Last Month / Qty on Order Next month / Qty shipped same current mo. last year/ Difference between Current mo. last year and current mo. this year(Formula)/ Difference of current & Previous Mos last year.

This is a total of 11 fields that most will need to be queried by month using the pop up query field. They will be grouped by customer number. Don't need any queries for item code or description. I really need to make this report fly for my new job. Can you help show me how to do it? I would really appreciate it!

Sincerely and Frustrated!

Dariusd13