Look up limiting query results

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

I've create a table for client info (title, name,
address, etc...) with the yes/no box to include them on
the a current mailing list. My problem is that the title
info is a look up list to a seperate table and not all
clients have a title listed.

When I build a select query for those to include in the
current mailing and I place the title field in the query
I only get the results that have the yes/no box on and
something in the title field.

How do I make the query show all with the yes/no box on
regardless of what's in the title field (i.e. if null)

Thanks for any help.

Ian.
 
Open your query in design view.

Double-click the line joining the tables.
Access pops up a dialog offering 3 options.
Choose the one that gives you all records from your main table.

This is known as an outer join.
More information:
http://allenbrowne.com/casu-02.html
 
Thank you so much -- hours of frustration and I figured
I'd messed up the join somehow.

Best Regards,

Ian.
Waterloo, Ontario, Canada
 
Back
Top