No Snaking

  • Thread starter Thread starter DS
  • Start date Start date
DS said:
Is there a way to have two columns in a report
and to turn off snaking?
Click to expand...

In Access 2003 and earlier, in the Page Setup Dialog box, Columns tab,
Column Layour, you have the choice of "Across then Down" or "Down then
Across". It's hard for me to imagine how you could be choosing columns
without that being obvious to you.

Larry Linson
Microsoft Office Access MVP
 
Perhaps I wasn't clear. I am quite aware of these two options. I was
trying to have two columns on a report without having to choose "Across then
Down" or "Down then Across". I was grabbibg at straws trying to figure out
how to have different criteria for each column.
Thanks anyhow Larry.
DS
 
If you're wanting records from different recordsources (and that includes
the same table/query with different criteria for each recordsource), you'll
need to set up separate subreports for each one. You can do that and set
them as narrow sub-reports side-by-side in the main report to obtain the
column effect you are wanting.

HTH,

Rob
 
Thanks Rob, I was trying to avoid the whole sub-report thing. What I ended
up doing is adding an extra field to each query. 1 as TYPE and 2 as TYPE.
Then I did a sort and group on TYPE twice and this gave me the desired
effect.
Thanks
DS
 
Back
Top