Two Column Report

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message m...
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

On Jul 28, 7:27*pm, "John... Visio MVP"
wrote:
"Steve" help_available_at_very_reasonable_ra...@contactme .com wrote in
messagenews:rpWdncHZ1uB1BvLXnZ2dnUVZ_radnZ2d@earth link.com...

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

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.

"Steve" wrote in message
m...
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.

On Jul 28, 8:46 pm, "Steve"
help_available_at_very_reasonable_ra...@contactme .com wrote:
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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message m...
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