Results 1 to 2 of 2
  1. #1
    vidplaylist is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Nov 2011

    Question Formula field

    I am using linked excel sheet as table in Ms Access.

    The problem is that i want to create a field in query which tell me that a particular field has formula.

    For example IF [amount] field has formula then "Calculated", "Manual".

  2. #2
    animaimmortale is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    syntax for the if statement would be,

    IIF([amount] = "YOUR CRITERION","Calculated","Manual")

    IIF([Field Name] = Criterion, Then do, Else)

    If it is just one formula then input the formula where it says your criterion. If there are multiple formulas try:

    IIF([amount] Like "=*", "Calculated", "Manual")

    For more info see

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

Similar Threads

  1. Formula mod help
    By jcaptchaos2 in forum Access
    Replies: 2
    Last Post: 04-25-2011, 02:55 PM
  2. Field in query formula question
    By jcaptchaos2 in forum Access
    Replies: 7
    Last Post: 04-24-2011, 06:32 PM
  3. SQL Formula to Sum Itself
    By Scorpio11 in forum Access
    Replies: 1
    Last Post: 02-19-2011, 11:22 AM
  4. Can I have an input variable in a field formula
    By FeatherDust in forum Queries
    Replies: 3
    Last Post: 09-20-2009, 06:40 PM
  5. Total based on Formula based on field value
    By cjbuechler in forum Reports
    Replies: 15
    Last Post: 07-10-2009, 09:56 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
Other Forums: Microsoft Office Forums