Rocko
|
| Posted: 03/19/2002, 1:08 PM |
|
Good morning all,
I don't know if this is the right place to look, but I'm going to put it out there anyway. Some of you guys have been real helpful in the past, and I thank you.
Anyway, here's the problem.
I'm trying to load an access query into my app, but the query is misshapen. Never been much on Access Queries, so maybe you guys can tell me what's wrong with it.
Here's the Access SQL code:
SELECT IIf(tblCityPAS_Area.FY<0,0,tblCityPAS_Area.FY) AS RevenueGrowth, tblCityPAS_Area.AREA
FROM tblCityPAS_Area;
What it's trying to do is convert values less than zero to zero.
But when it loads, all that shows up in the RevenueGrowth field is #Error
Any ideas?
|
|
|
 |
Sam M
|
| Posted: 03/19/2002, 8:12 PM |
|
Looks like it should work.
Looks to me like you need to check your data type
Good luck
-Sam Moses
|
|
|
|
|
