Report Results using =Count(*) and =Sum(Abs([

  • Thread starter Thread starter Charles G via AccessMonster.com
  • Start date Start date
C

Charles G via AccessMonster.com

Can I set my [Yes/No] check box in my Detail Section as such to only display
those records with a "No" statement?

I need to be able to count all the [Yes/No] records because of my =Count(*)
in my Report Header, but only want to display the "No" records in the Detail.

Report Header:
Lbl Number of PSC Tickets: =Count(*)
Lbl Cleared In 1 Day: =Sum(Abs([#OfDaysToClear]))
Lbl More Than 1 Day to Clear: =Sum(Abs([#OfDaysToClear]+1))

Page Header:
[Date of PSC] [PSC #] [Amount] [Error Type] [Date Cleared] [Cleared in 1
Day]

Detail:
[DateRcd] [PSC #] [Amount] [Error Type] [DateCld]
[Yes/No]

-Charles-
 
Charles said:
Can I set my [Yes/No] check box in my Detail Section as such to only display
those records with a "No" statement?

I need to be able to count all the [Yes/No] records because of my =Count(*)
in my Report Header, but only want to display the "No" records in the Detail.

Report Header:
Lbl Number of PSC Tickets: =Count(*)
Lbl Cleared In 1 Day: =Sum(Abs([#OfDaysToClear]))
Lbl More Than 1 Day to Clear: =Sum(Abs([#OfDaysToClear]+1))

Page Header:
[Date of PSC] [PSC #] [Amount] [Error Type] [Date Cleared] [Cleared in 1
Day]

Detail:
[DateRcd] [PSC #] [Amount] [Error Type] [DateCld]
[Yes/No]
Click to expand...


You can make the detail invisible by using a line of code in
the detal section's Format event:

Me.Section(0).Visible = Not Me.[yes/no]
 
Back
Top