Is there an easy way to write the results of a groupby query to a field in a different (unrelated) table as follows:
SELECT COUNT(ID) FROM tblTest
- Take this result value and write to a field called RecordCount in another table called tblSummary.
UPDATE tblSummary SET RecordCount = (SELECT COUNT(ID) FROM tblTest)
Except that this does not work...