I need a report that has two columns, that each have two columns...

  • Thread starter Thread starter Kelvin Beaton
  • Start date Start date
K

Kelvin Beaton

I'm trying to create a photo directory that looks like the following.



Photo 1 Photo 2 | Photo 9 Photo 10

Name 1 Name 2 | Name 9 Name 10

|

Photo 3 Photo 4 | Photo 11 Photo 12

Name 3 Name 4 | Name 11 Name 12

|

Photo 5 Photo 6 | Photo 13 Photo 14

Name 5 Name 6 | Name 13 Name 14

|

Photo 7 Photo 8 | Photo 15 Photo 16

Name 7 Name 8 | Name 15 Name 16



My hope is to use 8 ½"x 11" Landscape with two half pages. Each half page
having two columns.



Can someone help me format a report like this in Access?



I'm using Access 2003.



Thanks



Kelvin
 
Kelvin said:
I'm trying to create a photo directory that looks like the following.



Photo 1 Photo 2 | Photo 9 Photo 10

Name 1 Name 2 | Name 9 Name 10
Click to expand...

I don't see any clean solution. Access likes to go down the page.

Photo 1 Name 1 Photo x Name x
Photo 2 Name 2 Photo x+1 Name x +1

is a simple report.

What you want will probably take a good bit of coding.
 
I'm trying to create a photo directory that looks like the following.



Photo 1 Photo 2 | Photo 9 Photo 10

Name 1 Name 2 | Name 9 Name 10

|
Click to expand...
snip

Do the columns on the right side of the page always start with the same
records? ie: records 9 & 10. If not, are you tyrying to divide the records
roughly in half? ie 1 & 2 on the left an maybe 33 & 34 on the right. Do you
want records 17 & 18 and 25 &26 on the top of page 2?

Just a wizard prodder
Chuck
--
 
the numbers would continue onto the next page of the report...
Click to expand...
This is doable and without writing a single line of code. well, not *real*
code anyway.

Add a new field to your table. Name it: C. Data type: AutoNumber. Indexed:
Yes No Duplicates. Description: Record Counter.

Make a query that includes the Name, Picture, and the new field C.
Add 2 calculated fields to you query. First one: Col: [record]-(([record]-1)
Mod (4)). Col will determine if the data will be in the left or right column.
Second one: Pg: IIf(([record]-(([record]-1) Mod
(4)))<8,1,IIf(([record]-(([record]-1) Mod (4)))>7 And ([record]-(([record]-1)
Mod (4)))<16,2,IIf(([record]-(([record]-1) Mod (4)))>15 And
([record]-(([record]-1) Mod (4)))<25,3,4))). Pg will determine what page the
records will be on.

Make a report based on your Query. Add the Name and Picture in the detail
section. In Sorting and grouping, sort first on Pg, Sort Order: Ascending.
Keep Together: Whole Group. Sort second on Col, Sort Order: Ascending. Keep
Together: Whole Group. Sort last on C (Record Counter), Sort Order: Ascending.
Keep Together: Whole Group. Headers, Footers, as you want. Adjust vertical
size of picture so a column of 4 will fill the page. Your'e only going to get
4 pictures to a column anyhow, you might as well use all the page.

In report setup, set margins any way you want. Select *Landscape* for page
orientation. Select 2 columns. Space between columns as you want. Column
width equal to (page width minus left and right borders and minus space between
columns) /2. Column Layout: Down then Across.

Have fun.

Just a wizard prodder
Chuck
--
 
Error correction: Name the new field in the table: Record instead of: C.
And in the report sort last on: Record rather than C.

Hope this didn't cause too much aggravation.

A red faced wizard prodder
Chuck
the numbers would continue onto the next page of the report...
Click to expand...
This is doable and without writing a single line of code. well, not *real*
code anyway.

Add a new field to your table. Name it: C. Data type: AutoNumber. Indexed:
Yes No Duplicates. Description: Record Counter.

Make a query that includes the Name, Picture, and the new field C.
Add 2 calculated fields to you query. First one: Col: [record]-(([record]-1)
Mod (4)). Col will determine if the data will be in the left or right column.
Second one: Pg: IIf(([record]-(([record]-1) Mod
(4)))<8,1,IIf(([record]-(([record]-1) Mod (4)))>7 And ([record]-(([record]-1)
Mod (4)))<16,2,IIf(([record]-(([record]-1) Mod (4)))>15 And
([record]-(([record]-1) Mod (4)))<25,3,4))). Pg will determine what page the
records will be on.

Make a report based on your Query. Add the Name and Picture in the detail
section. In Sorting and grouping, sort first on Pg, Sort Order: Ascending.
Keep Together: Whole Group. Sort second on Col, Sort Order: Ascending. Keep
Together: Whole Group. Sort last on C (Record Counter), Sort Order: Ascending.
Keep Together: Whole Group. Headers, Footers, as you want. Adjust vertical
size of picture so a column of 4 will fill the page. Your'e only going to get
4 pictures to a column anyhow, you might as well use all the page.

In report setup, set margins any way you want. Select *Landscape* for page
orientation. Select 2 columns. Space between columns as you want. Column
width equal to (page width minus left and right borders and minus space between
columns) /2. Column Layout: Down then Across.

Have fun.

Just a wizard prodder
Chuck
Click to expand...
 
I'm trying to create a photo directory that looks like the following.



Photo 1 Photo 2 | Photo 9 Photo 10

Name 1 Name 2 | Name 9 Name 10

|

Photo 3 Photo 4 | Photo 11 Photo 12

Name 3 Name 4 | Name 11 Name 12

|

Photo 5 Photo 6 | Photo 13 Photo 14

Name 5 Name 6 | Name 13 Name 14

|

Photo 7 Photo 8 | Photo 15 Photo 16

Name 7 Name 8 | Name 15 Name 16


My hope is to use 8 ½"x 11" Landscape with two half pages. Each half page
having two columns.

Can someone help me format a report like this in Access?

I'm using Access 2003.

Thanks

Kelvin
Click to expand...
It can be done with 2 queries, 1 calculated field, and 1 report.

This is not really an Access problem. It is a logic problem.

Chuck
--
 
Back
Top