SELECT COUNT wrong sql

sal21 · Post by **sal21** » 17 Apr 2014, 20:35

Wath is wrong in this count based T.C

SELECT COUNT (*) AS TC1, WHERE T.C='12345678' AND T.[DATA_CONT] BETWEEN #03/05/2014# AND #04/04/2014#

Post by **HansV** » 17 Apr 2014, 20:38

Is C a text field or a number field? If it is a number field, you shouldn't use single (or double) quotes around the value.

sal21 · Post by **sal21** » 17 Apr 2014, 20:50

HansV wrote:Is C a text field or a number field? If it is a number field, you shouldn't use single (or double) quotes around the value.

TEXT

Post by **HansV** » 17 Apr 2014, 20:51

And what is the error message?

Eileen's Lounge