473,372 Members | 883 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

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.

Nov 12 '05 #1
4 4307
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.

Nov 12 '05 #2
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.


Nov 12 '05 #3
<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.
Nov 12 '05 #4
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.

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
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...
4
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,...
5
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....
2
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...
6
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 ...
4
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...
5
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...
5
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 ...
2
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...
0
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...
0
isladogs
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...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
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,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
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...
0
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.