Search results

Thanks again Pat..it's working perfectly!!

Pat, Thanks!!! It worked great! However... 3 things? 1. Is there a way when it omits that particular field on a record, that it shifts the other fields up so there isn't a space where the excluded one was. 2. In the code when I use a field name that has a space in it I get a compile...

Is there a way to use this to a distribution list? Robert

Here is my situation..I need to create a report based off of 1 table..but some records don't have data in some fields and some do. I need this report to omit the fields for each record where there is no data in the field. Example: I have 2 records..each has the field name of "mission" , 1...