Help with List() function
I am missing a key point, I think, in how the List() function works. I think that it's supposed to snag all instances of a field and list them, but I can't figure out to use it.
Here's what I need it to do: I have a list of students from about 300 schools. I need to find a subset of students and generate a list of those names to email to the contact person in each school. I have a List field, and I set it to be a calculated field with List(StudentName) as the calculation. That produces no results at all.
On the other hand, I started a quick test database and put two fields: Item and List. I set List to calculate as above, and it will list the item in the record, but not all of them. (I typed in five items just to see if it would list them.)
Question: What am I missing?