Sorted !

I'd still got brackets around the fields in the select statement

Liliana - I was just typing the above response when I received your latest post.

Thanks for your help -...

Thanks Liliana

That gives me what I thought I needed but when I run it in QA I  get an error - see below

INSERT INTO DBMON..Records (RunDate, DB, RecCount, TBName) Select(GetDate(),...