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.