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#
SELECT COUNT wrong sql
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: SELECT COUNT wrong sql
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.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4355
- Joined: 26 Apr 2010, 17:36
Re: SELECT COUNT wrong sql
TEXTHansV 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.
-
- Administrator
- Posts: 78475
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands