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 (AT) contactme (DOT) com> wrote in
message news:rpWdncHZ1uB1BvLXnZ2dnUVZ_radnZ2d (AT) earthlink (DOT) com...
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" <lancu... (AT) stonehenge (DOT) ca>
wrote:
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" <help_wanted_at_zero_rate (AT) clueless (DOT) com> wrote

Can-can? Is this for the Moulin Rouge?

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... (AT) contactme (DOT) com> wrote:
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

You're welcome. No charge.

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com

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 (AT) contactme (DOT) com> wrote in
message news:rpWdncHZ1uB1BvLXnZ2dnUVZ_radnZ2d (AT) earthlink (DOT) com...