Query Not showing data (2002)

[Leesha]

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

[HansV]

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.

[Leesha]

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

Thanks,
Leesha