Report displays no records

[windwardmi]

I have created a Report with a query record source using multiple tables.

The tables are filled by input into a detail form.

When I fill in all the data in the detail form I can call a Report showing the Data for a specific project no.

If I am missing one item of data and leave it's combo box empty on the detail form the report for that project no. does not show any data. I need to fill in that missing data to get a filled in Report.

What can be the reason for this to happen? Is there a property I might have missed that is toggled to require all data or none at all if one piece is missing in the Query?

[pbaldy]

This is a bit of a guess, but if you have the query in design view, right click on the join line between the relevant tables. Change the selection to "All data from table xxx" or whatever the verbiage is. That will change the join from the default, which requires matching values in both tables to return a record.

[windwardmi]

Tried to change joins and got following error:

"The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement. "

I'm novice. Will I have to start from scratch and set table relationships again and set up new query for report?

[pbaldy]

Can you post the db, or a sample containing the query and relevant tables?

[windwardmi]

Thought I posted this already. Attached is some info.

Can the DB be attached without data which might be confidential and not safe on the internet? And how is that done.

[windwardmi]

Anything further needed before I start from scratch with the Table reationships?