If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Two Column Report
"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 |
#3
|
|||
|
|||
Two Column Report
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. |
#4
|
|||
|
|||
Two Column Report
"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. |
#5
|
|||
|
|||
Two Column Report
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 |
#6
|
|||
|
|||
Two Column Report
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 |
Thread Tools | |
Display Modes | |
|
|