Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheGus

    Prompting for Date

    PHV, I got a ORA-01858: a non-numeric value was found where a numeric value was expected Ben, It will only let me choose VARCHAR2 as the data type!
  2. TheGus

    Prompting for Date

    I had it like that originally but it kept complaining that the date format was bnot correct even though it exactly matched the output of the date from other queries?
  3. TheGus

    Prompting for Date

    Using MSQuery, how do I ask the user to enter two dates for the start and finish of a BETWEEN statement? I have tried WHERE ENDDT BETWEEN '#' & [Enter Start Date] & '#','#' & [Enter End Date] & '#' but I get an error! Can anyone help?
  4. TheGus

    MSQuery Date parameter

    That doesn't work either! I have tried every combination of the above but can get it to work. Any other ideas
  5. TheGus

    MSQuery Date parameter

    I have created a query using MSQuery and I want the user to be able to enter a start date and an end date so that a range can be created. However, no moatter what format I use for the date in the input box, I keep getting an error that the format is wrong! Here is the part of the query that...

Part and Inventory Search

Back
Top