Count only records what i see in report

[deanvilar]

I cancelled some items in my report, when a field = YES, Cancel = TRUE ..but when I =count([assetNo]) still it counts the cancelled assetNo ....

[Rabbit]

What do you mean by you cancelled items on the report?

[deanvilar]

it means that the row from my report will not show when txtreleased = YES

[Rabbit]

And how are you preventing the row from being shown?

[deanvilar]

if me.released=YES then
   cancel = true
end if

[deanvilar]

I got it ...

created a textbox and placed an iif statement ... iif([released]="NO",1,0)

Then created another textbox to call that text to count the total

[Rabbit]

Please use code tags when posting code.

And that code sits where....?

If I had to guess, you have it in some sort of format or paint event on the report. Just because you're not displaying it doesn't mean it's not in the record source. And you are counting the record source, not what's visible. You don't need any of this VBA code or textboxes to sum up textboxes complication. You just need to filter your record source directly. You've overly complicated the situation.

[deanvilar]

sorry sir @rabbit for that ... i'll use code tags in my next posts....

that's 1 of the problem, because 1 of the fields in my report ENDDATE is fetched thru DMAX in detail format event of the report so there's a complication

[Rabbit]

There's probably no need to use DMax() through the format event either. I'm 99% sure that you've overly complicated the situation and there's no need for you to use any VBA code at all.

But I can't be 100% sure unless I know what the query is and what the code is doing.

[deanvilar]

it' a long story sir @Rabbit if I will explain it ... anyways ... I got the results I needed so for the meantime I'll stick with the vba coding =)

thanks for your time sir