Query shows no data in data view

I have an ACCESS db from a DEXA machine (bone scanner). The data is in
seperate tables and I want to link them so that I can query and create one
table with all the data I need from the seperate tables. When I try to
create a query with multiple tables in design view, if I run it to see the
data view, only the names of the columns appear, but no data from the
multiple tables that I have queried shows. If I bring only 1 table into
design view and query it, I have no problem. Thansk for any suggestions.

[Arno R]

I suppose there is just no data that matches your query

Have you joined the right fields? Are the join-fields the same type ?
Do you use INNER Joins? Perhaps you could try OUTER Joins

--
Hope this helps
Arno R
<sw*********@yahoo.com> schreef in bericht news:bj**********@mozo.cc.purdue.edu...

I have an ACCESS db from a DEXA machine (bone scanner). The data is in
seperate tables and I want to link them so that I can query and create one
table with all the data I need from the seperate tables. When I try to
create a query with multiple tables in design view, if I run it to see the
data view, only the names of the columns appear, but no data from the
multiple tables that I have queried shows. If I bring only 1 table into
design view and query it, I have no problem. Thansk for any suggestions.

[Speculator]

Post the SQL for your query.
On Wed, 10 Sep 2003 10:36:34 -0500, <sw*********@yahoo.com> wrote:

I have an ACCESS db from a DEXA machine (bone scanner). The data is in
seperate tables and I want to link them so that I can query and create one
table with all the data I need from the seperate tables. When I try to
create a query with multiple tables in design view, if I run it to see the
data view, only the names of the columns appear, but no data from the
multiple tables that I have queried shows. If I bring only 1 table into
design view and query it, I have no problem. Thansk for any suggestions.

[Pieter Linden]

<sw*********@yahoo.com> wrote in message news:<bj**********@mozo.cc.purdue.edu>...

I have an ACCESS db from a DEXA machine (bone scanner). The data is in
seperate tables and I want to link them so that I can query and create one
table with all the data I need from the seperate tables. When I try to
create a query with multiple tables in design view, if I run it to see the
data view, only the names of the columns appear, but no data from the
multiple tables that I have queried shows. If I bring only 1 table into
design view and query it, I have no problem. Thansk for any suggestions.

sounds like your tables are joined on a field with no values in
common, so all of your records are filtered out. If you want to test
it, outer join the tables by right-clicking on the join line and
selecting either a left or right join (2 or 3) instead of option 1.

[MSEagan]

I figured it out. I was using the key from the one to many table instead of
using it first from the many to one table, if that makes sense.
<sw*********@yahoo.com> wrote in message
news:bj**********@mozo.cc.purdue.edu...

I have an ACCESS db from a DEXA machine (bone scanner). The data is in
seperate tables and I want to link them so that I can query and create one
table with all the data I need from the seperate tables. When I try to
create a query with multiple tables in design view, if I run it to see the
data view, only the names of the columns appear, but no data from the
multiple tables that I have queried shows. If I bring only 1 table into
design view and query it, I have no problem. Thansk for any suggestions.