Results 1 to 6 of 6
  1. #1
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28

    Help-Syntax error in any calculated field

    I am getting syntax errors any time I try to create a calculated field using ANY built-in function! Code as simple as this in the Expression Builder gets an error:


    MyShortText: Left( [MyLongText] , 37)
    I am thinking must be an environmental issue, but cannot figure it out.
    Access 2010.
    Am I missing something?

    Help is most appreciated!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you checked for MISSING references?

  3. #3
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28
    I have checked - no MISSING references. What references should be there? I thought built-in functions were an integral part of the product... I did not have this problem when I was using Access 2003 and earlier. There are only tables and queries in this Access file (it is used by external web pages).

    Thank you.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  5. #5
    oldman is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Posts
    17
    The missing information in your specification is the source table name. The criteria should be [table name]![field]. It ends up being MyShortText: Left( [Table name]![MyLongText] , 37)

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The table name is only needed if disambiguation is required. If there is only one [MyLongText] field in the query then no table name is required. Something else is going on. Any chance you could post a sample db that demonstrates the issue so we can look at it?

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

Similar Threads

  1. Incomplete Syntax Clause (syntax error)
    By ajetrumpet in forum Programming
    Replies: 4
    Last Post: 09-11-2010, 10:47 AM
  2. Syntax Error Help with Recordset
    By ajetrumpet in forum Programming
    Replies: 11
    Last Post: 09-08-2010, 02:39 PM
  3. Syntax error
    By smikkelsen in forum Access
    Replies: 6
    Last Post: 04-28-2010, 09:38 AM
  4. Syntax Error
    By KLynch0803 in forum Programming
    Replies: 11
    Last Post: 02-04-2010, 01:45 AM
  5. sql syntax error
    By SMAlvarez in forum Access
    Replies: 1
    Last Post: 03-12-2009, 09:43 PM

Tags for this Thread

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