Query wont show data?

[louisa]

Hi all,

This will probably have an easy fix but i cant for the life of me work it out.
I have a split database.
I am trying to create a query, i go through all the normal steps and the name of the field gets displayed however none of the records are, it is just the name of the two fields i have selected. I have also tried to do this in a record but even that only brings up the names of the fields and displays nothing.

Any ideas?

 

[Rabbie]

You have not given us much info to work on so I need to ask some simple questions.

1. Is there data in the linked table? Can you see the data when you view the table?

2. Have you set any criteria in your query? Does any of the data match the criteria?

3. Which Version of Access are you using?

 

[louisa]

Hi, sorry.

1. Yes there is data in the tables and yes i can view it.
2. No criteria has been set, just the names of the fields i want to view.
3. Access 2003.

 

[Rabbie]

Thanks for the reply

Can you post your DB here so we can see what is going on? Or at least post the SQL of your query

 

[louisa]

SELECT Contacts.ContactID, Contacts.CompanyName, Network2.ContractEndDate
FROM Contacts INNER JOIN Network2 ON Contacts.ContactID = Network2.ContactID;
I have posted the SQL statement, i cannot post my db as it has been split.

Thanks for your help.

 

[MStef]

The query will not to work on wednesdays, effrontery.
Try to change a JOIN PROPERTIES.

 

[Rabbie]

SELECT Contacts.ContactID, Contacts.CompanyName, Network2.ContractEndDate
FROM Contacts INNER JOIN Network2 ON Contacts.ContactID = Network2.ContactID;
I have posted the SQL statement, i cannot post my db as it has been split.

Thanks for your help.

From what you say it seems that there are no records in Network where Network2.contactID has the same value as a record in Contacts.ContactID

Whithout seeing your data there isn't really any more we can do to help you.