Search results

Thanks RuralGuy, It took me awhile to get it right but your answer is what got me there. Appreciate the help.

In a report, I want to use the "Count" function to count the number of records in a column, but only if the field contains data. In other words, if I have 10 records, and 5 of them have data in the subject field, the total of the count should be 5. I can't use a running sum b/c the field is not...

Prefix Characters seems to do the same thing, or at least what I need it to do. Thanks so much for your assistance.

Thanks Bob, Under Group On, the only selections I have available are: Each Value and Prefix Characters (Using Access 2000)

This seems like it should be really simple. I've been trying to create a report with a list of last names grouped alphabetically. That is, all last names starting with "a" would be the first group, "b" the next group,etc. Can't seem to get it right. Thanks.