469,632 Members | 1,832 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

why did I lose some rows?

I have a main table of rows, and I created a query to put the customer
ID code and the product ID code for each row. But in the query results
I have a substantially less number of rows than in my original table.
There should be the same number of rows as in the original as all I
added were the codes.

Does anyone know what happened to the rows and how is the best way that
I can determine what's missing?

Also, is there some access tool like the excel autofilter so I could get
a quick view of what's in each field?

Thanks.

Matthew Kramer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
3 1204
Matthew Kramer wrote:
I have a main table of rows, and I created a query to put the customer
ID code and the product ID code for each row. But in the query results
I have a substantially less number of rows than in my original table.
There should be the same number of rows as in the original as all I
added were the codes.

Does anyone know what happened to the rows and how is the best way that
I can determine what's missing?

Also, is there some access tool like the excel autofilter so I could get
a quick view of what's in each field?

Thanks.

Matthew Kramer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Let's say you had a table called Table1. If I open it, it has 1000
records. If I create a query and enter
Select * from Table1
I should expect 1000 records.

If I enter
Select * from Table1 Where CustomerID Is Null
and 100 records don't have customer id fields filled in, I should expect
100 records.

Now, I may have two tables, Table1 and Employee. I create a
relationship line between Table1 and Employee based on EmployeeID. If
all records have an employee record, I should get back all records from
Table1. However, if the employeeID is blank, I'll get a return of only
the records that have a matching employee record. In this case, I would
dbl-click on the relationship line in the query builder and select the
option "Select all records and Table1 and those that match in Employee"
I will now get all records since it doesn't care whether or not there is
a matching Employee record.

You probably have a criteria that filters or a relationship link to change.
Nov 13 '05 #2
Matthew Kramer <mk********@hotmail.com> wrote in message news:<41**********************@news.newsgroups.ws> ...
I have a main table of rows, and I created a query to put the customer
ID code and the product ID code for each row. But in the query results
I have a substantially less number of rows than in my original table.
There should be the same number of rows as in the original as all I
added were the codes.

Does anyone know what happened to the rows and how is the best way that
I can determine what's missing?

Also, is there some access tool like the excel autofilter so I could get
a quick view of what's in each field?

Thanks.

Matthew Kramer

That's the nature of an inner join. If you want a "lossless" join,
you have to do an outer join. And, unlike Oracle for example, you
cannot create a full outer join in Access. Got questions, read the
help file on joins in queries.
Nov 13 '05 #3
Thanks for the explanations. - Matthew

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Steve Jorgensen | last post: by
1 post views Thread by Fraggle | last post: by
2 posts views Thread by jm | last post: by
10 posts views Thread by Michael SL | last post: by
8 posts views Thread by Neil | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.