I am trying to create a very basic query from our customers table which generates zip codes, city, and state. I would like to supress zip codes from showing more than once in the query. I have tried to select the "Supress Ident. Val" on form 2 of the Layout fields with no luck. Baan IVc4. Thanks.

From printing on the report or from the query? If from the query, then just use group by on the query for the fields. So you would probably need to group by on zip code, city and state.

Mark

Do u have any sort fields on the report. Sort fields seems to be mandatory.