The following query does'nt work in VB for an Access database. Any alternatives? Please...



SELECT DISTINCTROW Format$([CMLAP100].[TIMESTAMP], 'mm-dd-yyyy') as [TIMESTAMP], Sum([CMLAP100].[ABORT]) as ABORT, Sum([CMLAP100].[JAMCNT]) as JAMCNT, Count(*) as [Count Of CMLAP100] From CMLAP100 GROUP BY Format$([CMLAP100].[TIMESTAMP], 'mm-dd-yyyy')