Null Value Question

[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!!!

 

[Bob Howard]

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

Bob.

 

[Duane Hookom]

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]