Strip out seconds from a Datetime

[Clifford Bass via AccessMonster.com]

Hi,

DATETIME is an SQL reserved word, so that may be the problem. Try
enclosing all instances of it inside square brackets.

SELECT A.[DATETIME], ...

Clifford Bass

 

[Clifford Bass via AccessMonster.com]

Hi,

Glad to hear it. You are welcome!

Clifford Bass