Report not showing all records

[tyguy]

I created a report using the Report Wizard. I used fields from two different tables. I want the primary results to be from the primary table, and a subform/subreport created to contain the results from the related table. However, after I finished the wizard, it didn't show all the records from the primary table. Only the records that had related fields in the subform were displayed. If a record didn't have a related record in the subform, it just wouldn't show the primary record. (For example, in an address book with a subform containing children's names for each entry, if the entry doesn't have any children, that entry isn't included in the report at all.) Is there a certain feature that controls this? Thanks so much for any help. I'm using Access 2010.

[pbaldy]

It sounds like the report is based on a query, and that query probably has an incorrect join. With the query in design view, right-click on the join line between the two relevant tables and select the appropriate option. If you're not sure, post the SQL of the query here.

[tyguy]

I'm basing the report off two different queries. I'm doing this for an assignment, and I need to create a report w/ subform based off two queries. (One query contains all records from one table, and the other query contains all records from the other table.) I'm using one query for the report records, and one for the subform records. I checked, and I didn't have a relationship established between the two tables the queries were based on, so I did that, but it didn't fix the problem. Do I have to establish a relationship between queries (since I'm drawing from two different ones) as well as a table in order to do what I'm trying to accomplish?

[pbaldy]

Can you post the db?

[tyguy]

I have attached the db. I had to delete everything but the tables in order to upload it.

Even though I just included the tables. I have to do the assignment based off of queries which were merely copies of the respective tables.

So, if queries don't contain fields from multiple tables, but you plan on using two different ones in a report, do I have to establish a relationship between queries? I tried creating the report based off the tables (with the relationship established), but it didn't work. Thanks for the help.

[tyguy]

I just want to add that tblEntryListing is the primary table in the one-to-many relationship, and tblChildren is the related table. I want the report to show all results from the primary, and the results from the related in a subform if the related table contains records related to the primary.

[pbaldy]

You could probably have uploaded it by doing a compact/repair and then zipping. The tables alone aren't much help. I'd expect the report to be based on the main table and the subreport to be based on the many table, perhaps with master/child links keeping them in sync. You shouldn't need relationships established for this to work.