Results 1 to 5 of 5
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528

    Dealing With Expression Of The Form

    Hello Guys
    I have a query that contains the expression
    As the picture
    What I want is
    In the field (Field)
    Mark how the user can change the numbers (degrees) without access programmatically or in design
    Please Help


    Click image for larger version. 

Name:	11.JPG 
Views:	9 
Size:	41.6 KB 
ID:	15290

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Field is a reserved word. Should use a name other than Field.

    Don't really understand the question - what do you want to change numbers to other than what you show in the expression?

    There are fields named Computer, Maths, Statistics, Medical? Why does the average score determine which field value is displayed?

    Switch() could be used instead of nested IIf

    Switch([Expr1]>=80,[Computer]; [Expr1]>=70,[Maths]; [Expr1]>=60,[Statistics]; [Expr1]>=50,[Medical])
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much
    What I want is
    1. The user can change the names and numbers of the form of expression
    2. Change (There are fields named Computer, Maths, Statistics, Medical? Why does the average score determine which field value is displayed?
    ) By the user

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    You want the user to control what is displayed and you want them to be able to set the group breaks?

    Never seen anything like this.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Yes
    This is exactly what I want
    Attached Files Attached Files

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

Similar Threads

  1. Replies: 3
    Last Post: 06-12-2013, 04:03 AM
  2. Replies: 2
    Last Post: 04-15-2013, 03:05 PM
  3. Help - Query Dealing with Dates!!
    By bbanks2 in forum Queries
    Replies: 3
    Last Post: 12-18-2012, 11:31 AM
  4. Help dealing with duplicate records
    By jswenson3 in forum Access
    Replies: 12
    Last Post: 02-01-2012, 10:17 AM
  5. Having trouble dealing with these textboxes
    By blacksaibot in forum Programming
    Replies: 2
    Last Post: 04-28-2010, 12:10 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