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.
4  4308 
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.
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.
<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.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bernie |
last post by:
Greetings,
I have 3 servers all running SQL Server 2000 - 8.00.818. Lets call
them parent, child1, and child 2.
On parent, I create a view called item as follows:
CREATE view Item as...
|
by: Peter Bailey |
last post by:
I have a vba string taht dynamically creates the query which has two dates
in it that it grabs off an open form as a string from the textbox.
What I generate in vba is:
SELECT DOSMBK.Date,...
|
by: Andy Davis |
last post by:
I have a two tables, Users and Requests, the latter which displays the daily
log on's of 20 users. Both tables are related by a one-to-many relationship
in the Requests table via the UserId field....
|
by: a_munch |
last post by:
Hello, I was wondering if there's any way to create a report that will
show only rows from a query that meet certain criteria? I can't create
a second query that will pull only the records I need...
|
by: jjturon |
last post by:
Can anyone help me??
I am trying to pass a Select Query variable to a table using Dlookup
and return the value to same select query but to another field.
Ex.
SalesManID ...
|
by: spamsickle |
last post by:
I've created a query using the Query Designer under VB Express, and I
can execute it in the Query Designer to verify that it returns the data
I want. My database is called Area. It contains one...
|
by: Wired Hosting News |
last post by:
I tried to be breif and give a scenario so as not to be overlooked because
it was soooo long. Let me give you real world.
I am a manufacturer of goods and produce 11 items that are distributed...
|
by: Merennulli |
last post by:
To start with, I'll give a simplified overview of my data.
BaseRecord (4mil rows, 25k in each Region)
ID | Name | Region | etc
OtherData (7.5mil rows, 1 or 2 per ID)
ID | Type(1/2) | Data
...
|
by: existential.philosophy |
last post by:
This is a new problem for me: I have some queries that open very
slowly in design view.
My benchmark query takes about 20 minutes to open in design view. That
same query takes about 20 minutes...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
