PC,
Quote:
|
There migth be a way to pass-through the query direct to ODBC provider where floor function might work. But it is too technical for me so I will keep the simpler solution above.
|
A pass-thru might work IF Floor was supported in SQL ... It's not, unless a specific provider has made an extension to the standard SQL language to include a custom function.