Tags: access, database, duplicates, empty, field, finditin, hide, lines, microsoft, mysql, oracle, properties, report, selected, solution, sql

Empty lines in report

On Database » Microsoft Access

1,307 words with 1 Comments; publish: Mon, 31 Dec 2007 00:01:00 GMT; (25062.50, « »)

Hi everyone,

There's probably an easy solution to this little problem, but I can't find

it:

in the properties of my field, i selected hide duplicates 'yes'. As a

(logical) result, i have a number of empty lines, where the said duplicates

used to be.

Is there a way to remove these empty lines?

Thanks in advance

greetings from Belgium

Benny

All Comments

Leave a comment...

  • 1 Comments
    • Benny,

      Hide duplicates doesn't mean "hide duplicate records" - it means hide the

      group header or data point so it won't be repeated over and over. If you

      have blank lines, you may have true duplicate records, and that's a problem.

      Or maybe I'm not correctly visualizing what your report looks like.

      "Benny Eckert" <productie.ms-access.itags.org.boombuitenverlichting.be> wrote in message

      news:3fd4cfe1$0$5491$ba620e4c.ms-access.itags.org.reader3.news.skynet. be...

      > Hi everyone,

      > There's probably an easy solution to this little problem, but I can't find

      > it:

      > in the properties of my field, i selected hide duplicates 'yes'. As a

      > (logical) result, i have a number of empty lines, where the said

      duplicates

      > used to be.

      > Is there a way to remove these empty lines?

      > Thanks in advance

      > greetings from Belgium

      > Benny

      #1; Mon, 31 Dec 2007 00:03:00 GMT