Parameter Query Conversion Error

    Hello All,



    I have currently tried using Excel and the msquery wizard that comes with it. It has been relativley ok to use but now I'm expanding my queries into the database and attempting a parameter query by date. I keep getting a conversion error.


    Here is the code generated, any input or help would be greatly appreciated.
    INIH.INV stores dates in the form of MM/DD/YEAR



    SELECT INIH.
    FROM INIH INIH
    WHERE (INIH.INV=?)



    Thanks


    Nas

    Re: Parameter Query Conversion Error


    Thanks NBVC


    Nasim,

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *


    PM Dave Hawley if you agree to the rules


    VBA Noob

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login