View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 141
Default Q on Entering a Criteria within a Query

Could anyone explain the error below which I receive when I attempt to enter
a Criteria within the "Value" field of [From],[To] relating to a
CriteriaField "StaffNumber"

"Invalid Character Value for Cast specification (null)" - when I select
help, it says this error was returned by the driver

I use the same Value Field when I use to extract between 2 dates. How do I
use in the above situation i.e. when I am looking for a specific StaffNumber
(which I intend to select from the parameter, which will allow me more
flexibility)



Thanks