Re: Data Mismatch and Looping Distinct Results

2002-01-24 Thread Tyler Clendenin
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

Re: Data Mismatch and Looping Distinct Results

2002-01-24 Thread David Douglas
]> 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

RE: Data Mismatch and Looping Distinct Results

2002-01-24 Thread Mark A. Kruger - CFG
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

RE: Data Mismatch and Looping Distinct Results

2002-01-24 Thread Janine Jakim
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