Results 1 to 3 of 3

Thread: Lookup Filter

  1. #1
    Join Date
    Feb 2008
    Posts
    28

    Unanswered: Lookup Filter

    Hello,

    Could someone help me out with the best way to select only teachers from a certain school (the one which the student on the form attends)? My lookup right now reads:

    SELECT [First] & " " & [Last] AS [Teacher Full] FROM Teachers;

    This allows me to select any teacher i have in [Teachers].

    Thanks.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You'll need to add a WHERE clause
    George
    Home | Blog

  3. #3
    Join Date
    Mar 2008
    Posts
    2
    Quote Originally Posted by thaas
    Hello,

    Could someone help me out with the best way to select only teachers from a certain school (the one which the student on the form attends)? My lookup right now reads:

    SELECT [First] & " " & [Last] AS [Teacher Full] FROM Teachers;

    This allows me to select any teacher i have in [Teachers].

    Thanks.


    SELECT [First] & " " & [Last] AS [Teacher Full] FROM Teachers where [school field] ='SchoolName1'

Posting Permissions

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