Results 1 to 4 of 4
  1. #1
    mike02 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    245

    invalid string error in calculated field access form.

    Hey,
    I am trying to have a calculated field in my access form. I am inputing it in the control source, I am getting the error:
    Expression you have entered has an invalid string.

    Im confused, since this expression worked in my query, for another report.


    Code:
    = ((1+[F2T1])*(1+[F2T2])*(1+[F2T3])*(1+[F2T4])*(1+[F2T5])*(1+[F2T6])*(1+[F2T7])*(1+[F2T8])*(1+[F2T9])"(1+[F2T10])*(1+[F2T11])*(1+[F2T12]))-1
    Thanks,

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    My guess would be the " rather than * between 9 and 10.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    mike02 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    245
    thanks, missed that.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Calculated field #Name? error
    By Huddle in forum Access
    Replies: 9
    Last Post: 03-30-2014, 11:35 AM
  2. Replies: 8
    Last Post: 06-18-2012, 03:49 PM
  3. Math error in calculated field
    By nashgas in forum Queries
    Replies: 2
    Last Post: 04-03-2012, 11:49 AM
  4. Replies: 7
    Last Post: 02-29-2012, 06:37 AM
  5. Replies: 5
    Last Post: 09-17-2010, 09:48 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