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

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 Beaton wrote:
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


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.

Alternatively, you could create two reports that only use half the page.
One report uses the left half of the page, the second uses the right
half. You can set the column usage to be across then down and if there
is only enough vertical room for one image plus caption per page then
fine, Access will give you:


==============================|=================== ===========
+----------+ | +----------+
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
+----------+ | +----------+
[ pic name ] | [ pic name ]
page 1
==============================|=================== ===========
+----------+ | +----------+
| | | | |
| | | | |
| | | | |
| | | | |
| | | | |
+----------+ | +----------+
[ pic name ] | [ pic name ]
page 2
==============================|=================== ===========

and so on...

Print the first half of the images using this report, then, on the same
paper, (i.e. similar to manual duplex) print the second half using the
right-hand side version of the report.

Xed


--
Xed


------------------------------------------------------------------------
Xed's Profile: http://www.msusenet.com/member.php?userid=1197
View this thread: http://www.msusenet.com/t-1870514572

On Mon, 6 Jun 2005 08:15:23 -0500, "Kelvin Beaton" kelvin at mccsa dot com
wrote:

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

|
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...



"Chuck" wrote in message
news
On Mon, 6 Jun 2005 08:15:23 -0500, "Kelvin Beaton" kelvin at mccsa dot
com
wrote:

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

|
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
--

On Tue, 7 Jun 2005 14:01:22 -0500, "Kelvin Beaton" kelvin at mccsa dot com
wrote:

the numbers would continue onto the next page of the report...

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
--

On Wed, 08 Jun 2005 08:24:15 -0400, Chuck wrote:

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

On Tue, 7 Jun 2005 14:01:22 -0500, "Kelvin Beaton" kelvin at mccsa dot com
wrote:

the numbers would continue onto the next page of the report...

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

On Mon, 6 Jun 2005 08:15:23 -0500, "Kelvin Beaton" kelvin at mccsa dot com
wrote:

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

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
--