Blank Row in Report

[Guest]

Hi,

I'm creating a dynamic report from a query, which is being made
through a combo box in a form. The user selects a store name, and the report
comes up with all the information for that store. When I run the report,
there is a blank row that appears before all of the information. There are
not any blank rows anywhere in the database, but the report is adding one in
the report. Any ideas??

Thank you in advance,

-Matt

 

[Allen Browne]

If you open the query directly, does it have the blank row?

If not, then which section of the report is generating the blank?
Add a text box to the Detail section, and set its ControlSource to (say):
="zz"
If the zz shows on the blank row, then there is a blank record in the
report's RecordSource. If it does not, the blank row is coming form one of
the header sections.

 

[Guest]

Yes, when I open the query, it has a blank row.

The section I am having this problem is the Detail section.

I tried adding the ="zz" into a text box in the Detail section, and it
appeared on the report, but not in the query row.

There are no blank rows anywhere in the database and Access does not allow
me to delete the blank row after I run the query.

 

[Douglas J. Steele]

Is the entire row blank in the query, or just certain fields? Are you using
Left (or Right) Joins, so that it's showing Null for a row in one table that
doesn't have a corresponding entry in another one?

 

[Allen Browne]

Okay, so you now know that the blank row is coming from the query.

How many tables are in the query?
What kind of joins are you using?
Perhaps you would switch the query to SQL View, and paste the SQL statement
here.

 

[Guest]

The entire row is blank in the query. I am using a Left Join. I checked the
Object Dependencies and both tables have all of the information corresponding
to each other. I re-created the report and the same problem is occuring.