Access Query

[Guest]

I am having a query that I have created from 5 tables. It will not include
all of the records. It is only excluding a few. The query is a detailed
query. It seems like any new record entries are will not show up on the
query. Any help will be appreciated. Thanks.

 

[Guest]

It appears I have to have some date in each table for the full record to
show. Can I avoid this.

 

[Douglas J. Steele]

Assuming you're building this through the graphical query builder, check the
lines that are connecting the various tables. Select the line and check its
properties: you'll see there are 3 choices:

- Only include rows where the joined fields from both tables are equal.
- Include ALL records from 'Table1' and only those records from 'Table2'
where the joined fields are equal.
- Include ALL records from 'Table2' and only those records from 'Table1'
where the joined fields are equal.

Experiment until you get the combination you need.

 

[Guest]

Thank you Douglas.

Assuming you're building this through the graphical query builder, check the
lines that are connecting the various tables. Select the line and check its
properties: you'll see there are 3 choices:

- Only include rows where the joined fields from both tables are equal.
- Include ALL records from 'Table1' and only those records from 'Table2'
where the joined fields are equal.
- Include ALL records from 'Table2' and only those records from 'Table1'
where the joined fields are equal.

Experiment until you get the combination you need.