I don't know why it didn't work before, but it works now... Thanks!!!
Ok, well my problem is now I added in all the other values to have it
update, I followed the same format I currently have. When I go to
update it displays "Update 0 Rows" when I know that there is
information that is different... do I have to make 9 separate update
queries and then make a Union query to join them all together? I
guess I will get started on that, but it would be nice if I didn't
have to.
SQL:
UPDATE tblTestUpdate INNER JOIN tblImportProducts ON
tblTestUpdate.MaterialNumber = tblImportProducts.MaterialNumber SET
tblTestUpdate.Each = tblImportProducts!Each, tblTestUpdate.[Catalog] =
[tblImportProducts]![Catalog], tblTestUpdate.Manufacturer =
[tblImportProducts]![Manufacturer], tblTestUpdate.Category =
[tblImportProducts]![Category], tblTestUpdate.Description =
[tblImportProducts]![Description], tblTestUpdate.[Sub-Category] =
[tblImportProducts]![Sub-Category], tblTestUpdate.AddedNote =
[tblImportProducts]![AddedNote], tblTestUpdate.Required =
[tblImportProducts]![Required], tblTestUpdate.NoList =
[tblImportProducts]![NoList]
WHERE (((tblImportProducts.Each)<>IsNull([tblImportProducts].[Each]))
AND ((tblImportProducts.Catalog)<>IsNull([tblImportProducts].
[Catalog])) AND
((tblImportProducts.Manufacturer)<>IsNull([tblImportProducts].
[Manufacturer])) AND
((tblImportProducts.Category)<>IsNull([tblImportProducts].[Category]))
AND ((tblImportProducts.Description)<>IsNull([tblImportProducts].
[Description])) AND ((tblImportProducts.[Sub-
Category])<>IsNull([tblImportProducts].[Sub-Category])) AND
((tblImportProducts.AddedNote)<>IsNull([tblImportProducts].
[AddedNote])) AND
((tblImportProducts.Required)<>IsNull([tblImportProducts].[Required]))
AND ((tblImportProducts.NoList)<>IsNull([tblImportProducts].
[NoList])));
Thanks,
Matt Pierringer