Re: ACE report advice?

On 18 Jun 97 at 16:08, Jim Kistler wrote: > Is there a way to inform the report user that nothing was found in a > particular "group"? > > e.g. when using and "order by" statement that includes a table > column > named "category", I create "group" headers as in: As long as you have a null value (by using an outer join to the category table: > before group of category begin > IF category IS NULL THEN PRINT ..... > if category = "one" then > print ....... > > if category = "two" then > print ....... > > etc.... > > end { before group of category } HTH. -- Ciao, Billy Nose to the ground and ear to the grindstone in: Kuwait