Expression Builder problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
Group footer i have to display Total records. Some of the
records
are blank, so when i print report it shows Total records -
Click to expand...
10 (but if one is blank) i need to display - 9.
I never used Expression Builder before - my Question: How
Click to expand...
can i print Total record with some critiria.
If i build expression like this =Count(TempTicks!
Click to expand...
TicketNo) then i will get all record includes blanks.
 
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
 
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.
 
Back
Top