i will assume quarter is another column therefore you are missing a comma.
try:
SELECT
DISTINCT SalespersonID,
SalesAmount,
Quarter
FROM tblSales
Where Quarter = 1
- Original Message -
From: "David Douglas" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, Januar
]>
Sent: Thursday, January 24, 2002 11:29 AM
Subject: RE: Data Mismatch and Looping Distinct Results
> I'd say the datatype for quarter is not an int or number - trye usi
ng
single
> quotes:
>
> where quarter = '1'
>
> -Original Message-
> From: D
I'd say the datatype for quarter is not an int or number - trye using single
quotes:
where quarter = '1'
-Original Message-
From: David Douglas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 6:27 AM
To: CF-Talk
Subject: Data Mismatch and Looping Distinct Results
Morning Al
Is quarter really a number field? If it's a text it should be '1' or
'#Form.ffQuarter#'
-Original Message-
From: David Douglas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 9:27 AM
To: CF-Talk
Subject: Data Mismatch and Looping Distinct Results
Morning All,
2 issues are b
4 matches
Mail list logo