counts the number of records

[azhar2006]

I have a form letter as a report, that has 2 subreports that print supplemental information. Currently,
When there is data that fills this subreport, it fills in , "Grows"


Do there that counts the number of records that would be displayed... and if it is greater than 0, then print out the normal concatenation... but if it ='s 0, then print out "None".

[June7]

What do you mean by 'normal concatenation'?

Here is what I do. Have label on report with caption. If subreport does not have data, then display the label.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.lblOU.Visible = Not Me.ctrOU.Report.HasData
Me.lblCO.Visible = Not Me.ctrCO.Report.HasData
Me.lblRC.Visible = Not Me.ctrRC.Report.HasData
End Sub

[azhar2006]

Thank you very much June
What I mean is if there are 10 records in the report I want to see only the last 5 records
Where I put in a field numbering records in the report these characteristics
Name: txtcounter
Control Source: = 1
Running Sum: Over Group
Visible: No

[azhar2006]

I have tried with this but did not succeed

 If [Seq] Mod 5 = 0 Then
        Me.Detail.ForceNewPage = 5
    Else
        Me.Detail.ForceNewPage = 0
    End If

[June7]

That would not be valid code for what you want.

What if there are 20 records - what should happen?

[azhar2006]

Thank you What is the solution then? If I have 10 records in the report or 12 or 16 .... etc.. I want to show only the last five records, only Is it possible

[June7]

This is a very unusual requirement. Never seen anything like it. Why don't you just limit the report recordset to 5 records? Perhaps:

SELECT TOP 5 * FROM tablename WHERE {some criteria here} ORDER BY [somefield] DESC;

[azhar2006]

Thank you very much JuneHe has worked wonderfully Thank you June