"Mark" <mark@home.com> wrote in message
news:OwwRZ5AlDHA.2488@TK2MSFTNGP12.phx.gbl...

> SELECT jobcode, min(salary) as sal, min(Division) as Div, min(jobtitle) as
> jobtitl, min(ID)as thisId, min(category) as thiscat
> FROM jobs group by jobcode
>
> And it works fine but now i need to filter Division
> i've tried using this....
> WHERE Division = "Tec"
>
> but that wont work, not sure why
> can anyone tell me how to apply the filter to that statement

>-----Original Message-----
>"Mark" <mark@home.com> wrote in message
>news:OwwRZ5AlDHA.2488@TK2MSFTNGP12.phx.gbl...
>
>> SELECT jobcode, min(salary) as sal, min(Division) as
Div, min(jobtitle) as
>> jobtitl, min(ID)as thisId, min(category) as thiscat
>> FROM jobs group by jobcode
>>
>> And it works fine but now i need to filter Division
>> i've tried using this....
>> WHERE Division = "Tec"
>>
>> but that wont work, not sure why
>> can anyone tell me how to apply the filter to that
statement
>
>Is it the double quotes? How about:
>
> WHERE Division = 'Tec'
>
>Steve
>
>
>.