View Single Post
  #7 (permalink)  
Old 11-05-03, 15:56
basicmek basicmek is offline
Registered User
 
Join Date: Oct 2003
Location: Roanoke, Va
Posts: 445
Question

Quote:
Originally posted by M Owen
Gregg,

Problem is trying to use the Floor function within a query ... That requires SQL functions to which Floor is not one of them.
M

He mentioned VBA, and it sounded like the SQL might be created in code so that's where I was coming from. He could still create a custom function in a standard module that wraps around the Excel function and achieve the same result couldn't he?

Gregg
Reply With Quote