Results 1 to 2 of 2
  1. #1
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89

    Syntax Error in Sharepoint

    Greetings,

    I need to create a calculated column based on the following:

    IF[Lodging] ="On-Campus" [Number of Students] + [Number of Instructors]*$1,200.00
    IF[Lodging] ="Off-Campus" [Number of Students] + [Number of Instructors]*$1,500.00
    IF[Lodging] ="Non-EMI Facility" [Number of Students] + [Number of Instructors]*$1,800.00



    I don’t know if its an “IF” statement or not. I basically would like data entered from the columns in [] above to calculate based on the formula or one that will actually work to a separate column that I will name “cost assumptions” in currency format. The goal is to total the cost assumption column up automatically in Sharepoint as a running tracker that can be filtered by Cadre.

    any help would be appreciated...

    v/r
    novice

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I would use a Select Case statement behind a form for a desktop DB. Since you are talking about Web Forms, (something I know nothing about) I will guess you will want to do the calcs in a query object.

    So a nested IIF is probably the answer. Create an alias and add a nested Instant If.

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

Similar Threads

  1. Replies: 11
    Last Post: 05-01-2014, 11:56 AM
  2. Replies: 0
    Last Post: 03-24-2014, 09:35 AM
  3. Replies: 3
    Last Post: 01-23-2014, 07:49 AM
  4. Replies: 6
    Last Post: 05-30-2012, 12:32 PM
  5. Incomplete Syntax Clause (syntax error)
    By ajetrumpet in forum Programming
    Replies: 4
    Last Post: 09-11-2010, 10:47 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