Report over Crosstab qry

P

Pedro

Hi everyone
I have a report over a crosstab qry that shows me some
values for each group (department) for all year from Jan
till Dec. So far i have values on almost all months except
Sep, Oct, Nov and Dec. How can multiply some value by the
number of months that has a value? That is great that 0.
Carefull, cose some records has values from Mar or Apr and
not from Jan.
Tks in advance
Pedro
 
D

Duane Hookom

What are your column and row headings Depts or Months or other?
Could you type a few example rows into an email and explain with a little
more detail?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping a Report made with a cross tab qry 11
Subtract on a report based on QRY cross table 14
formatting report using crosstab query 1
Repeating data in reports 1
Crosstab qry not adding up 1
Add FY to Report header 3
weird sum on report 2
Need help with SQL Statement in MS Access 2003 Chart 11

Top