Search results

Hi All, I've a two tables (new) and (Old) and like to compare the values the sql and output shown below select 'TableA' , costcentre, count(costcentre) as Total Count, sum(values) as TotalAmt from TableA group by costcentre UNION ALL select 'TableB' , costcentre, count(costcentre) as...

Hi All, I have a control datbase , and I would like to copy/paste the table using the VBA code. Meaniang copy the X table from "CoreDB"(SourceDB) into "TargetDB". I'm trying to used the following VBA code but getting some errors Option Compare Database Option Explicit Sub CopyTbl() Dim...