Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    5

    Unanswered: Input Box for Query in MS Access

    I have a large table on which I am running a query to find a specific item of data, however the data changes all the time.

    What I need is to add an expression into the query to popup and input box to ask "What is your query data?"

    I can't remember how to do this. can anyone help

    Thanks

    NR

  2. #2
    Join Date
    Feb 2002
    Location
    Dublin, OH
    Posts
    10
    Enter the question you want to pop up surrounded by brackets in the criteria field of the querie.

    i.e. If you have an address table and want to retrieve all the records for a specified state, enter the following in the criteria block for the STATE field:
    [Enter state to retrieve]

    If you want to be able to enable wildcards, you could do the following in the last name field:
    LIKE [Enter last name or partial last name] & "*"
    Patrick Mildenberg

Posting Permissions

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