Line/Border format

[rblair11]

I'm trying to create a report that will look like the attached spreadsheet (it was the easiest way I could come up with to explain what I need).

The report is grouped. The biggest problem I'm having is trying to draw a line after the last record in each group. At this point I've only drawn lines with the line tool.

If I can provide any additional information that will help explain what I am looking for please let me know.

Thank you.

 

[Smart]

Can you post your dbase So I can have a look at the report ?

 

[rblair11]

I can post the DB but I don't want to waste your time. The report I have designed and the report I want to create are 2 different things.

Maybe I can ask a more specific question. The report is based on 2 tables as shown below.

tblSubmittals
Submittal_ID (PK)

tblSubmittalRevisions
Submittal_ID (FK) (Grouped by on Report)
field 1
field 2
field 3

After seraching for a few more hours I think what I need to do is:

1. determine when I've hit the last record in the detail section. Remember my report is grouped. I'm thinking I could use a DMAX lookup to determine the last record in a grouping.

2. draw a line under the text boxes in the design portion and set it to not visible.

What I wanted to do is create code that would check for the last record and set the line to visible for that record. That way I would have a "bottom" to by "table view' when printed but I would not print horizontal lines between every record.

Is this the appropirate approch? I haven't gotten it to work yet.

I will keep trying and once I get closer I will post the DB. That way you're not trying to solve multiple problems that I've created.

If there are any suggestions based on the above I would love to try them. Thanks for your time.