Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GVeers
Starting Member
9 Posts |
 Posted - 2008-10-20 : 17:46:22
|
| I apologize if this is a catastrophically stupid question. However, when I attempt to use the FLOOR function, I get the following error:"Undefined function 'FLOOR' in expression."The actual code I used (just for testing purposes) is:DoCmd.RunSQL "UPDATE TempRF_rank SET Tier = FLOOR(10.5);"The only thing I can think of is that FLOOR() is a newer SQL function and is not supported by my version of SQL. Any thoughts?I appreciate the help! |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-20 : 17:59:04
|
| FLOOR is available in SQL2000 |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-20 : 19:02:35
|
| Are you using Microsoft SQL Server?CODO ERGO SUM |
|
|
|
GVeers
Starting Member
9 Posts |
Posted - 2008-10-21 : 09:15:41
|
quote:
Originally posted by Michael Valentine Jones
Are you using Microsoft SQL Server?CODO ERGO SUM
I'm using MS Access 2003. That should support SQL Server, right? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-10-21 : 09:25:53
|
| Floor is not supported in Access. UseUPDATE TempRF_rank SET Tier = INT(10.5)MadhivananFailing to plan is Planning to fail |
|
|
|
GVeers
Starting Member
9 Posts |
Posted - 2008-10-21 : 09:44:38
|
| Thanks Madhivanan, it works like a dream! I appreciate it! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-10-21 : 09:49:21
|
quote:
Originally posted by GVeers
Thanks Madhivanan, it works like a dream! I appreciate it!
You are welcome  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
FLOOR() function