Null Value Question

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

Guest

I have a form that is used to enter up to 10 names of people attending a
meeting. The names are picked from a lookup table.

I'm trying to create a report that shows how many people came to the
meeting. Not the names who came, just how many people came.

I tried using the ISNull command, but seem to be getting sketchy results. I
can't figure out why it's giving incocnsistent results, but am thinking it a
name was entered, and then erased, maybe the field isn't null any longer.

Is there a better way? How do I essitially count which fields have a name
in them, and then report that number?

Thanks for your help!!!
 
Not only test for Isnull([xxxx]) --- also test If [xxxx]="" (an empty
string)

Bob.
 
I think a better way is possibly to normalize your table structure. 5 people
at a meeting should create 5 records in a related table. To count the number
of people at a meeting, use a totals query:
SELECT Count(*) as NumOfAttendees
FROM tblMeetingAttendees
WHERE MeetingID =[Enter meeting ID]
 
Back
Top