Results 1 to 5 of 5

Thread: Report Problems

  1. #1
    jirizarry
    Guest

    Report Problems

    I know that there is a simple answer to this, but I haven't been able to find it yet. How you you make a form NOT include a line that has no data in it?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Problems

    Are you talking about a continuous form, a datasheet, a subform, or <big>a REPORT</big>? Your subject says "report" but your question says "form". None of your tables should have records with no data in them, so are you talking about the "empty record" you get from an outer join? If you're more specific about what you're trying to accomplish, someone can probably help you out.
    Charlotte

  3. #3
    jirizarry
    Guest

    Re: Report Problems

    I'm sorry about the confusion. I can explain a little bit more. I work for a corp. that has a lot of engineers and there are a lot of drawings that are requested. Because our customer is from another country, we have to keep a record of what drawing are being requested and by whom. I made (what I thought was simple) database in Access. I made a form so that it would be easier for everyone to use. In the form, they can request up to 10 drawings at one time, but not many people need that many. When I tried to make a report to show the control numbers, the blank lines were taking up a lot of room. Is there a way to make a report that would include a line that had data and know not to include a line that had no data?

  4. #4
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Problems

    Presumably the report runs from a query, just use the Is Not Null in the criteria for the field in question.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Problems

    Why are you hard-coding a maximum number of drawings? It leads me to think you have everything in a "flat file" (i.e. everything in one table without related tables). How about setting up a related table that holds the drawing requests? You can then use a subform for the drawing information and either appropriate grouping in your report or subreports. That way, you see everything that was requested and only what was requested (i.e. no blanks).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •