Expression Builder problem

[Guest]

Hi, Al
I am using Access 2002
I created detail reports with one level GROUP BY in the Group footer i have to display Total records. Some of the record
are blank, so when i print report it shows Total records - 10 (but if one is blank) i need to display - 9
I never used Expression Builder before - my Question: How can i print Total record with some critiria
If i build expression like this =Count(TempTicks!TicketNo) then i will get all record includes blanks
The next expression doesn't work!!
=Count(TempTicks!TicketNo) Where TempTick!ActCode = "10

Please Hel

 

[Fons Ponsioen]

Hi Elena.
One way you could do that is, in the footer you can use a
unbound textbox and enter there in:
=Sum(IIf([YourData] Is Not Null,1,0))
Now YourData is the name of the data element in your table
you wish to count.
Hope this helps.
Fons

-----Original Message-----
Hi, All
I am using Access 2002.
I created detail reports with one level GROUP BY in the

Group footer i have to display Total records. Some of the
records

are blank, so when i print report it shows Total records -

10 (but if one is blank) i need to display - 9.

I never used Expression Builder before - my Question: How

can i print Total record with some critiria.

If i build expression like this =Count(TempTicks!

TicketNo) then i will get all record includes blanks.

 

[Guest]

Hi, Fon
Thank you for reply, i am trying but it doesn't wor
=Count(IIF([TempTick!]Is Not Null,1,0)) am i missing something

Hel

 

[Guest]

Thank you, it works
I just didn't pay attention than =Sum comes with parameters 1,0, i was using Count which comes with 1,Null.