Results 1 to 4 of 4
  1. 02-20-2011, 12:40 PM #1
    noblesm1975
    noblesm1975 is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    2

    Question Query

    I am doing an assignment for school. I have a query that has 2 tables joined. There is a technician field along with customer fields. I want to make all technicians show up, even if they have no customers. How do I do this? Set some sort of criteria? Here are all of the fields listed... Technician Number, Last Name, First Name, Client number, Client Name, Billed. I have to have all of these fields and have all technicians show up. One is not showing, who has no customers (clients). Help?
    Reply With Quote Reply With Quote
  2. 02-20-2011, 01:00 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Use a LEFT Join rather than an INNER Join. The Query Builder know how to do this.
    Reply With Quote Reply With Quote
  3. 02-20-2011, 03:41 PM #3
    noblesm1975
    noblesm1975 is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    2

    Thumbs up thanks!

    It worked!
    Reply With Quote Reply With Quote
  4. 02-20-2011, 03:44 PM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    Thanks for posting back with your success. Are you ready to use the Thread Tools and mark this thread as Solved?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums