Two Column Report

[Steve]

How can can code be run for each row in a two column report? For example,
1 record = 1 row
2 records = 1 row
3 records = 2 rows
4 records = 2 rows
5 records = 3 rows
etc

Thanks!

Steve

 

[John... Visio MVP]

How can can code be run for each row in a two column report? For example,
1 record = 1 row
2 records = 1 row
3 records = 2 rows
4 records = 2 rows
5 records = 3 rows
etc

Thanks!

Steve

I have no idea what you are talking about, but I can create you a database
to do it for a reasonable fee.

Your description does not make sense.
1 - "code be run for each row"?
2 - two column report - but no mention of columns

or do you mean:
That all even records are in column A and all odd records are in column B.
If the number of records are odd, then nothing is in column B of the last
row.

Column A Column B
Record 1 Record 2
Record 3 Record 4
Record 5 Record 6
Record 7

John... Visio MVP

 

[Keven Denen]

I have no idea what you are talking about, but I can create you a database
to do it for a reasonable fee.

Your description does not make sense.
1 - "code be run for each row"?
2 - two column report - but no mention of columns

or do you mean:
That all even records are in column A and all odd records are in column B..
If the number of records are odd, then nothing is in column B of the last
row.

Column A    Column B
Record 1     Record 2
Record 3     Record 4
Record 5     Record 6
Record 7

John... Visio MVP

Ya, if you are willing to pay a small fee for my time and knowledge,
I'm sure I could create a database for you to do what you want Stevie.
John's will probably be better, but mine will cost less.

 

[Keith Wilby]

How can can code be run for each row in a two column report?

Can-can? Is this for the Moulin Rouge?

For example,
1 record = 1 row
2 records = 1 row
3 records = 2 rows
4 records = 2 rows
5 records = 3 rows
etc

You sound like a clueless newbie. We can't see you screen and we don't have
a copy of your file so what you've written is meaningless.

 

[James A. Fortune]

How can can code be run for each row in a two column report? For example,
1 record = 1 row
2 records = 1 row
3 records = 2 rows
4 records = 2 rows
5 records = 3 rows
etc

tblIntegers
ID AS AutoNumber
N AS String
ID N
1 1
2 2
3 3
4 4
5 5
6 etc

qryGetResults:
SELECT IIf(N="etc","etc",CStr(N) & " record" & IIf(N<>"1","s") & " = "
& CStr((N+1)\2) & " row" & IIf(CInt(N) >= 3, "s", "")) AS Result FROM
tblIntegers;

!qryGetResults:
Result
1 record = 1 row
2 records = 1 row
3 records = 2 rows
4 records = 2 rows
5 records = 3 rows
etc

Thanks!

Steve

You're welcome. No charge.

James A. Fortune
(e-mail address removed)

 

[Larry Linson]

You can run code for each record / detail section by putting it in the
Format or Print event of the Detail Section. There are no events applying to
a "row" in a two column report. Only if you chose "Across Then Down" would
there even, necessarily, be a concept of a "row".

Larry Linson
Microsoft Office Access MVP