Results 1 to 4 of 4
  1. #1
    Beanster is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    2

    Entering a few numbers at the beginning of a field


    I have a very, very simple one-table database that contains a list of transactions and 4 other fields. The transaction field is 10 characters. I've created a parameter query which prompts the user to enter the transaction number to pull the record [Enter transaction number]. But this requires the user to enter all 10 characters to find the record. I would like the user to be able to enter any number of leading characters and have the query return all results that match. How can I do that?

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Use the word LIKE and the asterisk in the criteria.

    So, the criteria wo8uld be

    Like [Enter transaction number] & "*"

  3. #3
    Beanster is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    2
    THANK YOU!
    THANK YOU! I love you. It's so simple I cannot believe I couldn't think to add all those elements together. You've really made my day!
    Now, how do I post this as SOLVED?

  4. #4
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by Beanster View Post
    Now, how do I post this as SOLVED?
    I just did it but you go to THREAD TOOLS on the menu bar at the top of the thread and select the drop down there.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-11-2011, 02:18 PM
  2. Replies: 2
    Last Post: 09-25-2011, 08:52 AM
  3. Replies: 3
    Last Post: 03-05-2011, 12:46 PM
  4. Entering 16 digit numbers into number field
    By chrismid259 in forum Access
    Replies: 7
    Last Post: 12-14-2010, 10:40 AM
  5. Calculating Beginning and Ending page numbers
    By sabraham in forum Access
    Replies: 3
    Last Post: 01-07-2010, 12:36 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