True you do not need to include fields specified in the Where clause in the field list also. But in his case, he did need it in the field list also because he was using that field in the report.

>Mark & Bonnie,
>
>I don't think you need to have the field specified in the WHERE clause in the list of fields.
>Mark