Re: Data type correct for some records, not for others

["semi star gazer" <webforumsuser@xxxxxxxxxxxxxx>]

Thanks for all of your replies! I know that the queries are messy right now, 
but what confuses me is that the records that were present before I added new 
records with an append query display perfectly, while I get the above error 
ONLY with the records that were added with the append query in Access. There is 
always a value for practiceTypeID, and it works correctly with older records! I 
can't figure it out. The field types are exactly the same, and even if I go 
into the database and retype in the practiceTypeID in the mentors table in one 
of the new records, it still throws the error.