Results 1 to 3 of 3

Thread: [RESOLVED] Query an Asterisk

  1. May 14th, 2009, 07:34 AM #1
    fEtchboi88
    fEtchboi88 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2008
    Posts
    294

    Resolved [RESOLVED] Query an Asterisk

    This isn't really a visual basic question, and it's probably really easy, but how can you run a query in Access for fields with an asterisk (*) in it. It keeps treating * as a wildcard and giving me the entire table.
    Reply With Quote Reply With Quote
  2. May 14th, 2009, 09:14 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Query an Asterisk

    Wrap the asterisk in square brackets.

    Like "[*]*" - Starts with *
    Like "*[*]*" - Contains a *
    Like "*[*]" - Ends with *
    Reply With Quote Reply With Quote
  3. May 14th, 2009, 09:45 AM #3
    fEtchboi88
    fEtchboi88 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2008
    Posts
    294

    Re: Query an Asterisk

    haha i knew it was something simple.

    Thanks dude.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width