Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2005
    Location
    Wichita, Kansas, USA
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Blank fields in a query (2007)

    I'm sorry if this has been addressed somewhere before--I have looked and didn't find anything answering this:
    I have a query based on three tables. One of the tables has some empty fields. Those records with some empty fields are not returned by the query. If I enter data into those fields, then those records are returned. If you need more information, let me know.
    Warren

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

    Re: Blank fields in a query (2007)

    You may get the results you want by double-clicking the join lines between the tables in the query design and playing with the options.

Posting Permissions

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