Report Problems

Topic

New Reply

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?

Reply | Quote

Replies

Are you talking about a continuous form, a datasheet, a subform, or a REPORT? 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.

Reply | Quote

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?

Reply | Quote

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

Reply | Quote

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).

Reply | Quote