Q on Entering a Criteria within a Query

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
I don't think your problem is related to the fact that you are trying to use
a parameter but rather the SQL statement is having trouble, perhaps related
to the value of the parameter. The error message implies a problem with the
CAST function in SQL which seems to be erroring out because it is looking at
a NULL. To diagnose I would need to see the SQL statement and the values of
the parameters you are using when you get the error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adv Filter fails in macro, works manually 32
SUMPRODUCT anomoly 2
Drawn Objects Q 2
remembering the same filtering criteria 13
Enter Parameter Value in Access Form 0
Input Box Q 3
Setting Criteria in VBA 5
LEFT JOIN returns a single space instead of NULL 8

Back
Top