Re: Export a report and removing blank entries

From: Rick B (Anonymous)
Date: 03/22/05


Date: Tue, 22 Mar 2005 15:00:24 -0600

If a field is blank for a given record, then nothing will print.

Not sure I understand. Paint us a picture. Post a few sample lines.

Rick B

"Leroy" <Leroy@discussions.microsoft.com> wrote in message
news:38132633-97C7-482B-9A1E-7920FAA7A19D@microsoft.com...
> Yes, I am trying to complete a database I built a couple of weeks ago, and
> I'm having trouble with the report part of it. I basically have several
with
> different fields, 23 different fields to be exact. I built the report but
> some of the entries only require two of the fields to be printed, and the
> rest to "disappear". I am having trouble to get that part of it to work,
so I
> was wondering if anyone has any suggestions on how to go about it. I was
> thinking of the possibility of writing an export function that put the
> information into a word document but passes over any null values. I just
> started with access a month ago so my knowledge is still very limited. Any
> useful information would be greatly appreciated.



Relevant Pages

  • Re: Code to change color of field depending on another fields results
    ... Use conditional formatting. ... built in. ... Rick B ... > I have a report that's build on a query. ...
    (microsoft.public.access.reports)
  • Export a report and removing blank entries
    ... Yes, I am trying to complete a database I built a couple of weeks ago, and ... I'm having trouble with the report part of it. ... I am having trouble to get that part of it to work, ... useful information would be greatly appreciated. ...
    (microsoft.public.access.reports)
  • Exporting a report and removing null values
    ... Yes, I am trying to complete a database I built a couple of weeks ago, and ... I'm having trouble with the report part of it. ... I am having trouble to get that part of it to work, ... useful information would be greatly appreciated. ...
    (microsoft.public.access.reports)
  • Exporting a report and removing null values
    ... Yes, I am trying to complete a database I built a couple of weeks ago, and ... I'm having trouble with the report part of it. ... I am having trouble to get that part of it to work, ... useful information would be greatly appreciated. ...
    (microsoft.public.access.reports)
  • Exporting a report, and removing null values
    ... Yes, I am trying to complete a database I built a couple of weeks ago, and ... I'm having trouble with the report part of it. ... I am having trouble to get that part of it to work, ... useful information would be greatly appreciated. ...
    (microsoft.public.access.reports)