Display 50 records in a report field in two columns of 25

[bmal]

If this topic has been thoroughly hashed out I apologize.

The thing is I cannot find a definitive article that says this can or cannot be done.

The idea is to display in a report a field with 50 records in two separate columns of 25 records.

Is this possible or am I completely off the reservation?

thanks

 

[CJ_London]

It can be done but is not a normal function. To display, the way you would do it is to have two subreports on your main report. That is the easy bit

The harder bit is deciding which 25 records to display in each subreport, you can use SELECT TOP 25 for one subreport, but there isn't a standard concept of NEXT 25.

You might be able to do it by having two queries Qry1 and Qry2. Your Qry1 query would be something like

SELECT TOP 25 * 
FROM myTable 
ORDER BY ID

and your Qry2 query would be something like

SELECT TOP 25 myTable.* 
FROM myTable LEFT JOIN Qry1 ON myTable.ID=Q1.ID 
WHERE Q1.ID Is Null
ORDER By myTable.ID

 

[Mihail]

In design view go to Page Setup tab on ribbon and hit the button "Columns".
Make your settings in the window that will pop up.

This feature exist in Access 2007. I don't know if it is already in 2003.

I think that in my access (2007) is a bug: the records will be displayed in 2 (or more) columns but the labels are showed only in the first column.
Know anyone if this is really a bug or I don't know to make all settings ?