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
|
|||
|
|||
Grouping, counting and an event
I am working in Access 2003.
I want the report to list out the first 5 records and then draw a line for separation. Then read the next 5 and draw a line and so on until EOF. Example: Smith, John Adams, John Q. Lincoln, Abraham Clinton, Bill ______________________________ Washington, George Jefferson, Thomas etc, etc, etc Any suggestions? I have a few other reports I need to design that will have to do this separation with a line but at a different interval. This one happens to be at 5. Thanks for your input, -J |
#2
|
|||
|
|||
Grouping, counting and an event
1. Add a text box to your report, and give it these properties:
Control Source =1 Running Sum Over Group Format Fixed Decimal Places 0 Fore Color 16777215 Name txtCount This gives you a text box that counts the records in your report, but shows nothing (white on white.) 2. Select this text box, and choose Conditional Formatting (CF) on the Format menu. Set Condition 1 to: Expression Is ([txtCount]-1) Mod 5 = 4 Then click the bucket icon in the CF dialog, and choose black (or whatever color line you want.) 3. Place this line below the other text boxes in the section, and reduce its Height property 0.01" or however fat you want your line to be. For your other reports, change the 5 to the number of records you want between lines, and the 4 to 1 less than the number of lines, e.g. for a line very 10 records the CF expression would be: ([txtCount]-1) Mod 10 = 9 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "JJurek" wrote in message news I am working in Access 2003. I want the report to list out the first 5 records and then draw a line for separation. Then read the next 5 and draw a line and so on until EOF. Example: Smith, John Adams, John Q. Lincoln, Abraham Clinton, Bill ______________________________ Washington, George Jefferson, Thomas etc, etc, etc Any suggestions? I have a few other reports I need to design that will have to do this separation with a line but at a different interval. This one happens to be at 5. |
#3
|
|||
|
|||
Grouping, counting and an event
Allen,
PERFECTO! I made one small mistake. In the control source I put "1" and not "=1" Exactly what I was looking for, Thanks again!! "Allen Browne" wrote: 1. Add a text box to your report, and give it these properties: Control Source =1 Running Sum Over Group Format Fixed Decimal Places 0 Fore Color 16777215 Name txtCount This gives you a text box that counts the records in your report, but shows nothing (white on white.) 2. Select this text box, and choose Conditional Formatting (CF) on the Format menu. Set Condition 1 to: Expression Is ([txtCount]-1) Mod 5 = 4 Then click the bucket icon in the CF dialog, and choose black (or whatever color line you want.) 3. Place this line below the other text boxes in the section, and reduce its Height property 0.01" or however fat you want your line to be. For your other reports, change the 5 to the number of records you want between lines, and the 4 to 1 less than the number of lines, e.g. for a line very 10 records the CF expression would be: ([txtCount]-1) Mod 10 = 9 -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "JJurek" wrote in message news I am working in Access 2003. I want the report to list out the first 5 records and then draw a line for separation. Then read the next 5 and draw a line and so on until EOF. Example: Smith, John Adams, John Q. Lincoln, Abraham Clinton, Bill ______________________________ Washington, George Jefferson, Thomas etc, etc, etc Any suggestions? I have a few other reports I need to design that will have to do this separation with a line but at a different interval. This one happens to be at 5. |
Thread Tools | |
Display Modes | |
|
|