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/