PC Review


Reply
Thread Tools Rate Thread

count the nulls in a report calculation

 
 
Rose
Guest
Posts: n/a
 
      13th Apr 2010
What is input into the label boxes to all count those fields within a
grouping that a blank. The Category is RSVPDate
--
Rose
 
Reply With Quote
 
 
 
 
Duane Hookom
Guest
Posts: n/a
 
      13th Apr 2010
I think you mean text boxes rather than label boxes. To count the number of
records in a report section where the RSVPDate is null, you add a text box
in the Group Header or Footer with a control source of:
=Sum(Abs(IsNull(RSVPDate)))

--
Duane Hookom
MS Access MVP


"Rose" <(E-Mail Removed)> wrote in message
news:707464D4-405C-4F4A-BD0E-(E-Mail Removed)...
> What is input into the label boxes to all count those fields within a
> grouping that a blank. The Category is RSVPDate
> --
> Rose


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Nulls & Not Nulls in Reports RoadKill Microsoft Access Reports 2 28th Jul 2008 06:16 PM
Using Count in a Report with Nulls =?Utf-8?B?YXJpYQ==?= Microsoft Access 1 13th Sep 2005 10:34 PM
Count nulls in report Marie Microsoft Access Reports 6 9th Mar 2004 11:40 AM
Need to Count Nulls marywoody Microsoft Access Queries 1 22nd Jan 2004 09:27 AM
Count nulls Razor Microsoft Access Queries 1 9th Dec 2003 02:13 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:19 AM.