Query Not working with newly imported table

[SkinsFan2626]

I have a database with multiple tables. I recently updated my customer table
in excel and imported it into my database. I deleted the relationship to the
old table and created a relationship to the new table. I re-created an
existing query to bring back fields from the new table. The query is designed
to bring back all customers that are not in my Customer table. This way I can
see which Customers I need to put into my customer table. If Table 1 is all
sales to any customer, and Table 1 and the Customer table are linked by an
account number. I run a query of all Table 1 fields with the account field
from the Customer table. I put "Is Null" as criteria for the Account field
from the customer table, but it won't bring back customers that are not in
the Customer table, which is the opposite of what I want it to do. It used
to work but now with the new table it doesn't. Also, why do some of my
queries still work when the relationship to the old table has been deleted?

Any and all help is greatly appreciated.

 

[Jeanette Cunningham]

Hi,
Here is how to find where your new table is different from your old table.
Open both the old table and the new table in design view.
Minimize the database window, click window, tile vertically.
Now you have both tables in design view, side by side - Check each field to
make sure you have the same name, the same data type, the same field size,
the same default values( if any), the same indexes (if any) and the same
validation rules ( if any).
Save any changes to the new table.

When both tables are set up exactly the same in design view, the queries
should work again.


Jeanette Cunningham -- Melbourne Victoira Australia