I used an append query to pull data from an old database that is being replaced. The field I am having issues with is the ClientID field. The ClientID is an autonumber field. The old database had a ClientID field in it with the same properties (and autonumber). After importing the data, which looks fine btw, the imported records will not show up in any query pulling the ClientID. The original test records I had in the new database, which were replaced with the data from the old database, are all that appear in the query. Is there a way to fix this?