Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Query Not showing data (2002)

    Hi,
    I'm attaching a stripped down version of a database. The query runs fine with the exception of it doesn't show the data in the [contact name} field when its pulling from tblcontactnamesbackup. If I use the [contact name link] in tblsalesactivitybackup it shows the number but I need the name that it is referreing to in tblcontactnamesbackup. I'm not sure what is wrong.

    Thanks,
    Leesha
    Attached Files Attached Files

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

    Re: Query Not showing data (2002)

    You're linking on an ID number vs a name. That won't work.

    You need to do the following:

    - Open tblSalesActivityBackup in design view.
    - Change the data type of the Contact Name Link field from Text to Number.
    - Save and close the table.
    - Open the query in design view.
    - Delete the join from Contact Name Link in tblSalesActivityBackup to Contact Name in tblContactNamesBackup.
    - Create a join from Contact Name Link in tblSalesActivityBackup to ID in tblContactNamesBackup.
    - Double click the join line and select the option to include ALL records from tblSalesActivityBackup.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query Not showing data (2002)

    Oh God Hans! I should've caught that one on my own. Too much going on here!

    Thanks,
    Leesha

Posting Permissions

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