Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    14

    Unanswered: Setting Criteria for Query

    I have a query where when I input data in the criteria the query responds correctly. For example if I input = 1234 in the field it returns all the data with that information. However, if I use a parameter for user input [Plese input Number:] it does not function properly. Why would this vary if I input the same data via directly or via an inputbox? And better yet, how can I correct this issue?

    Thanks,

    MET

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Please post the SQL expression of the query as well as the data structure of the table(s) involved.
    Have a nice day!

  3. #3
    Join Date
    Feb 2006
    Posts
    14
    I resolved this issue by using a wildcard. LIKE[PLEASE input Number:] & "*". Thanks..
    Last edited by Metrazal; 06-10-14 at 13:50. Reason: Typo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •