Results 1 to 4 of 4
  1. #1
    elender is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2017
    Posts
    5

    Parameter value but no brackets!

    Hi all,


    I am relatively new to Access, so please excuse the layman's terms.

    I built a query that calculates values according to what data a user enters into a field. Please see the expression that is typed into the column below.

    LS1Value: Switch([LS1]=Yes,1,[LS1]=More Or Less,1)

    The language here ("More or Less") cannot be changed as it corresponds to a survey and needs to reflect that survey exactly. A score is calculated based on the survey answers.

    When I try to run this query, the parameter value box pops up and I can't seem to get it to stop. As you can see, I do not have brackets around the words "More or Less". I also ensured there were no brackets in the SQL view. There is also nothing in the criteria row.

    Could this be because the words "more" and "less" are some kind of automatic identifiers in Access? Any guidance would be greatly appreciated.

    Thanks!

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    More Or Less seems to be an actual value, not a variable. In which case it needs to be surrounded by quotes, just like you wrote it in the next sentence.

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

    Parameter value but no brackets!

    The issue here I suspect is the or. Try putting "more or less" and maybe even "yes" as these are strings so without the quotes the query looks for variables


    Sent from my iPhone using Tapatalk

  4. #4
    elender is offline Novice
    Windows 10 Access 2007
    Join Date
    Feb 2017
    Posts
    5
    Yes! The quotations worked!
    Thank you so much for the help.

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

Similar Threads

  1. Concatenate 2 field with brackets
    By jj1 in forum Access
    Replies: 4
    Last Post: 02-13-2016, 06:40 PM
  2. Replies: 4
    Last Post: 12-05-2014, 11:15 AM
  3. Replies: 6
    Last Post: 06-06-2014, 11:02 AM
  4. Replies: 1
    Last Post: 07-12-2013, 01:15 PM
  5. Search for brackets
    By stocktsi in forum Access
    Replies: 3
    Last Post: 11-14-2011, 06:18 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums