Results 1 to 2 of 2
  1. #1
    dcecil is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2009
    Posts
    12

    Question Creating input box for query

    I am fairly new to Access. I am using Access 2007 and am trying to make it run a query by popping up an input box and then running a query that "contains" the string that is input. In other words, if I have a field called TITLE and I run the query and I put Microsoft in the input box, it will query the TITLE field and return all records with Microsoft in it, regardless of what else the field contains (MS Access, MS Word, etc.).



    I hope I explained this well enough...

  2. #2
    Flanders is offline Novice
    Windows Vista Access 2007
    Join Date
    Jun 2009
    Posts
    7
    What you need is a Parameter Query. I think you can use the Like command to focus it a little more.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-31-2009, 10:43 AM
  2. Replies: 0
    Last Post: 04-26-2008, 09:59 AM
  3. Creating INT function within a Query
    By LCorrieri in forum Queries
    Replies: 3
    Last Post: 01-25-2008, 10:38 AM
  4. Replies: 0
    Last Post: 02-14-2007, 01:35 PM
  5. Creating multiple reports from one Query
    By Mike Cooper in forum Reports
    Replies: 5
    Last Post: 04-24-2006, 05:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums