Newby: Data Doesn't Display When I Run a Query on Two Tables

[formula1]

Hi there everyone,

I have been trying to complete an assignment for a computer course and I have run into a real stumbling block in respect to getting data from my two tables to display in a query.

Here's the essentials of my problem:

I am using Access 2007 for this assignment and I have tried to upload my database everyone can look at it, however, the upload process keeps failing for some reason.

1) Doing the queries is not a difficult exercise really, so it's not as if I'm having trouble learning how to formulate a query. I'm using the query wizard. Anyways, when I do a query on ONE of my tables, no problem, the data displays perfectly as per my query.

2) When I do a query with data fields taken from both tables, no data actually displays, only the field headings of those that I chose in my query.

3) I have tried to do queries from multiple tables in Northwind, and they worked perfectly. This leads me to believe that there is a problem with how I have related my two tables, but I don't know exactly.

I'm trying for make a query containing the required data from my two tables so that I can do a mail merge document. I have been working on this problem all day with no progress. Does anyone here have any ideas on this? I have followed all the directions from my Access books and the online help. They are fine of course, but this problem is not mentioned anywhere.

Thanks everyone

Formula1

 

[WIS]

Hi there everyone,

I have been trying to complete an assignment for a computer course and I have run into a real stumbling block in respect to getting data from my two tables to display in a query.

Here's the essentials of my problem:

I am using Access 2007 for this assignment and I have tried to upload my database everyone can look at it, however, the upload process keeps failing for some reason.

1) Doing the queries is not a difficult exercise really, so it's not as if I'm having trouble learning how to formulate a query. I'm using the query wizard. Anyways, when I do a query on ONE of my tables, no problem, the data displays perfectly as per my query.

2) When I do a query with data fields taken from both tables, no data actually displays, only the field headings of those that I chose in my query.

3) I have tried to do queries from multiple tables in Northwind, and they worked perfectly. This leads me to believe that there is a problem with how I have related my two tables, but I don't know exactly.

I'm trying for make a query containing the required data from my two tables so that I can do a mail merge document. I have been working on this problem all day with no progress. Does anyone here have any ideas on this? I have followed all the directions from my Access books and the online help. They are fine of course, but this problem is not mentioned anywhere.

Thanks everyone

Formula1

What are the join flds. Pls list the fld name, data type and indexed type for both join flds and we may be able to help you. eg CustomerID, Long, No Duplicates.

 

[formula1]

Ok, I have two tables: Speakers and Sessions.

Speakers Table:

Primary Key:Speaker ID(This is joined to the Speaker ID field in the Sessions table)
Data Type: Autonumber
Field Size: Long Integer
Indexed: Yes(No Duplicates)

Sessions Table:

Primary Key: ID
Data Type: Autonumber
Field Size: Long Integer
Indexed: Yes(No Duplicates)

Now, to relate these two tables I have joined the Speaker ID field in the Speakers table to the Speaker ID field in the Sessions table. I simply made the Speaker ID field in Sessions to facilitate this relationship.

Speaker ID field in Session table

Data Type: Number
Field Size: Long Integer
Indexed: Yes(No Duplicates)

I hope this helps in diagnosing the problem here. I appreciate all of your efforts. I also attached the database in 2002-2003 form so you could have a look at it, even though I'm using the 2007 version.

Formula1

 

[formula1]

Has anyone ever had this problem in one of their database queries?

 

[formula1]

Also, when it comes to the "Join Type" that is selected for this relationship and query it says in the "Join Properties" box:

"Only include rows where the joined fields from both tables are equal"

Now I have experimented with the other two join settings and the query output will include the data from one of the tables but not the data from the other table. Both sets of field heading are displayed, but only one table's data values are displayed.

 

[WIS]

Formula1

You have the same listed under General. I've answered yr questions there.

WIS