query does'nt work in VB

[sriky]

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')

[Michael Nattfalk]

Hi.

Have you tried changing the single-quotation marks('), in the format expressions, to double-quotation marks(")?

regards,
Michael Nattfalk