Updating Record Count to Another Table plus add text
INSERT INTO RecordCount_Before ( TableNamesCount )
SELECT Count(tblXrefInfo.Item) AS CountOfItem
In the field "TableNamesCount" I need the "Table Name" from the other table added to the update.
So the updated field would be :
tblXrefInfo.Item count is 660234