Access 2003 help -- sql server new users

Raymond D'Anjou
10/25/2005 3:20:18 PM

I don't know much Access but can't a simple math function work:
select columnName/90 -1

[quoted text, click to view]

magikgb via SQLMonster.com
10/25/2005 7:13:42 PM

Can someone tell me how i can create an iif function to do the following?

I need to look a field that has an amount in it. if it is 90K or less make it
1 if its 180 to 90001 make it 2 etc...

So for every 90K in that amount add 1..

I tried to do a VB code to create a ceiling funciton but Access keeps giving
me an error saying that my function is undefinded? Had a friend run my code
and it worked for him. I did update to the most current service pack and it
still errors out...

Can anyone tell me how I can make either the function work or how to do an
iif function to make it work?

sql server new users : Access 2003 help