Displaying reports

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a database with 10 columns of data. After I sort
the data, I want to display some of the columns on a
report in the following manner, and I want the report to
display two sets of columns on each page. Furthermore, I
want to include a column showing the rank of each record,
as also shown below:

Rank Column1 Column3 Column5 Rank Column1 Column3 Column5
1. xxxxxxx xxxxxxx xxxxxxx 6. xxxxxxx xxxxxxx xxxxxxx
2. xxxxxxx xxxxxxx xxxxxxx 7. xxxxxxx xxxxxxx xxxxxxx
3. xxxxxxx xxxxxxx xxxxxxx 8. xxxxxxx xxxxxxx xxxxxxx
4. xxxxxxx xxxxxxx xxxxxxx 9. xxxxxxx xxxxxxx xxxxxxx
5. xxxxxxx xxxxxxx xxxxxxx 10. xxxxxxx xxxxxxx xxxxxxx

Can someone explain how to do this?

Thanks very much,
Bob
 
Open your report in design view. From the File menu, choose Page Setup, and
set the Columns to 2, down then across.

Make sure you have the Width of the report narrow enough for 2 columns plus
the left and right margins.

For a row counter, add a text box with these properties:
Control Source: =1
Running Sum: Over Group

If you true ranking where the counter shows the same for two rows that have
identical values, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208946&Product=acc2000
 
Back
Top