Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    London, Gtr London, United Kingdom
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    box fill query (a2000)

    Hi,

    I have 2 tables

    table 1 has 3 fields Airport Code (restricted to 3 letters), Country and Location. (i.e. type in LAX and the Country field = USA and the Location = Los Angeles

    table 2 is a normal contact database, Company, name, address etc.

    I am trying to write a query that asks for the 3 letter code which when input would return all of the information from table 1 and selected information from table 2 such as Company name, address, telepone etc.

    the airport code from table 1 is a lookup in table 2.

    If the above is possible is it possible to have it displayed in the format

    Example Company
    Example Street
    Example Town
    etc.

    rather than

    Example Company - Example Street - Example Town etc.

    Would appreciate some advice.

    Thanks

    Steve

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: box fill query (a2000)

    You need to create a query which includes both tables, with a join between table 1 and table 2 using the lookup field. Then simply put a parameter in the criteria for the airport code - see Help for "parameter query" if you aren't familiar with that concept. You will probably get multiple records for a given airport code.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: box fill query (a2000)

    A query always displays fields in columns and records in rows, but that shouldn't matter because you don't (or shouldn't) want end users to work directly with queries.

    You can display data much more flexibly in a form and/or report based on the query. Fields can be next to each other, or below each other, or whatever you like.

Posting Permissions

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