join not working?

[James Warburton]

When I link a further table onto my query, the returned no
of records drops. I don't want this so I change the join
to return all records from the table that was part of the
original query. Trouble is the query then still returns
the reduced no of records.

Are there circumstances under which a join asking for all
records from one of the tables does not return all those
records?

Thanks in advance

 

[[MVP] S. Clark]

If you add a WHERE clause.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Jeff Boyce]

James

The "type" of join can control what you're seeing. If you add/join a table
that doesn't have as many of the IDs on which you join, a normal join will
reduce the number of rows.

Right-click on the join, and select "show all of Table1 and any of Table2
that match" (actual syntax may vary).

Good luck

Jeff Boyce
<Access MVP>

 

[Van T. Dinh]

The join from the Table(s) already in the Query to the added Table can and
will influence the number of rows returned.

Suggest you briefly describe your Table(s), what you want the Query to
select and post the SQL String of your Query.