Results 1 to 2 of 2
  1. 08-22-2014, 01:42 PM #1
    Sigzop
    Sigzop is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2014
    Location
    DC
    Posts
    5

    Need help with an expression


    I have this excel expression that works great. any ideas with examples of how to translate it to access =if(sum(G10:G11)=2,$C$3*$D$3,0)
    Reply With Quote Reply With Quote
  2. 08-22-2014, 02:31 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,648
    Are you using this in a textbox in report footer section? Maybe:

    =IIf(Sum([fieldname])=2, "this value", "other value)
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Reference result of expression in another expression
    By eschmidt12 in forum Queries
    Replies: 5
    Last Post: 09-25-2013, 09:35 AM
  2. Expression builder does not show other query fields to add to an expression.
    By canast in forum Queries
    Replies: 2
    Last Post: 11-20-2012, 03:21 AM
  3. Expression to complex in query expression (switch)
    By Bertrand82 in forum Queries
    Replies: 4
    Last Post: 10-26-2012, 12:49 AM
  4. possible to have an expression within an expression?
    By sfgiantsdude in forum Access
    Replies: 1
    Last Post: 01-05-2012, 05:10 PM
  5. LIKE '* [expression] '
    By melanie in forum Access
    Replies: 6
    Last Post: 12-28-2011, 04:03 AM

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

Other Forums: Microsoft Office Forums