Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Ms Access: Concatenation including quotation marks in expression

    Dear Loungers,

    I want to construct this string in a query criteria: Like "*[search string question]*"
    where the search string is supplied by me at the time of running the query, the question will be something like "Which product title?", and based on that should resolve to a criteria o: Like "*a day in the life of*".

    How can i do this?

    Thank you.............................. liz

  2. #2
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Not exactly sure what your doubt is? Is this a query to be run as a query object? Is it a SQL statement to be run as part of VBA code?

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Liz,

    You can do this in the Criteria field of the Query:
    Like "*" & [Which product title?] & "*"
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. The Following User Says Thank You to RetiredGeek For This Useful Post:

    lizat (2012-08-09)

  5. #4
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Hi Retired Geek, saved my bacon once again, Thank you!!!!

Posting Permissions

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