Change the query the report is based on to a crosstab query.   The wizard will 
walk you through setting one up.  It's like making a pivottable in excel.

-------------- Original message -------------- 

> Hi 
> 
> One more help in report, Is it possible to format the report to show the data 
> in the following way(landscape) 
> 
> Month : June July 
> ========= ==== 
> Item Qty Qty 
> ------ ----- ---- 
> Item1 5 7 
> Item2 4 9 
> Item3 10 25 
> 
> now in my report it shows one after another, i.e. month june first under that 
> July. I have tried it in grouping and sorting, but did not work. Please 
> advise. 
> 
> Thanks 
> 
> 
> --------------------------------- 
> Start your day with Yahoo! - make it your home page 
> 
> [Non-text portions of this message have been removed] 
> 
> 
> 
> 
> Yahoo! Groups Links 
> 
> 
> 
> 
> 
> 

[Non-text portions of this message have been removed]



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AccessVBACentral/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to