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

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
 
M

Mike Painter

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

Xed

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 righ
half. You can set the column usage to be across then down and if ther
is only enough vertical room for one image plus caption per page the
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 sam
paper, (i.e. similar to manual duplex) print the second half using th
right-hand side version of the report.

Xe
 
C

Chuck

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

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

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

Chuck

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to sort data into multiple columns on the report. 3
Help!! find two number recurring numbers in row?? 1
Gears 14
not user if this is a bug that was fixed or my memory gone bad... 2
Arriving at totals 2
Ranking 3
Finding the right style field in VBA 0
Countifs or a pivot 1

Top