08-05-2004, 09:01 AM | #1 (permalink) |
Upright
|
[SQL] MSAccess Where Clause with Case statement syntax error...
Is there something obviously wrong with this where clause?
Code:
WHERE rt_BEHI_BHBH.Index = ( CASE WHEN qry_BEHI_values.BHBHValue < (SELECT MIN(Value) FROM rt_BEHI_BHBH) THEN 1 WHEN qry_BEHI_values.BHBHValue > (SELECT MAX(Value) FROM rt_BEHI_BHBH) THEN 10 ELSE (SELECT Index FROM rt_BEHI_BHBH WHERE Value = qry_BEHI_values.BHBHValue) END ) |
08-11-2004, 03:48 AM | #3 (permalink) | |
Tilted
Location: Jersey City
|
Quote:
Will it work as a pass-through query? We do a lot of this where I work when someone needs Access to interact with an outside database. Access tries to format all SQL into Access-deformed-SQL unless you specify that the query is a pass-through query. (Not sure if this will help if your data is in Access as well). w0
__________________
My other sig says something clever. |
|
Tags |
case, clause, error, msaccess, sql, statement, syntax |
|
|