SQL Function in Access - Experts Exchange - The network for technology professionals.

Date() is an intrinsic function within Access which a database like Oracle would not understand. A pass-through query sends the SQL to the database that houses the data. That database would not know anything about the Access function. Joe

www.experts-exchange.com