Problem with footer logic when only one detail record

T

toolsgg

I have a report where I want to supress the details if the group total is
less than a certain amount. This works fine as long as there are more than
one detail record in the group. If there is only one record, the code is
run, but the record is not supressed. The logic I am using is as follows:
If Val([txtTotalHours]) > 0.166 Or Forms![Billing
Worksheet]![chkInclude10] = -1 Then
Me.Detail.Visible = True
If [txtDetailCount] > 1 Then
Me.GroupFooter0.Visible = True
Else
Me.GroupFooter0.Visible = False
End If
Else
Me.Detail.Visible = False
Me.GroupFooter0.Visible = False
End If
Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem filtering detail records 7
Formatting based on total in Footer 1
Detail_Format works in Print Preview but Not When Printing 0
Conditional Footer Code 5
Case Approach Not Consistant 3
conditional detail format 2
Suppress total for first record of a group 1
Report details 0

Top