Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add blank line to detail report section on demand 1

Status
Not open for further replies.

ssecca

Programmer
Feb 13, 2002
219
US
I would like to add a blank line to the detail section of a report based on the value found in the report.

inv# Amount
1234 $50.00
1235 $50.00
(I want this to be a single inserted blank line when the amount changes)
1236 $60.00
(Blank Line)
1237 $63.00

I have no problem with using VBA or some other method if someone can advise. Thanks

ssecca
 
Create a group based on the amount. Add a footer for that group and make it as wide as you need it for the blank line.
 
The old adage "Keep It Simple Stupid" surly applied here. Here I was trying all these wild and crazy things when the answer was so simple and easy.

THANK YOU very much!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top