Results 1 to 4 of 4

Thread: Syntax Error In SQL Update Query Statement

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    Member Transformer's Avatar
    Join Date
    Mar 2012
    Posts
    91
    Rep Power
    14
    Quote Originally Posted by ashu1990 View Post
    for those searching the same answer;
    i got it working the reason error occured was due to no space given after each "="

    cheers
    Hi Ashu,
    It was not beacause of no spaces after '='. You were getting an error because there is a field named 'Action' in your table,that is a keyword.Put that in square brackets. e.g. [Action]
    Last edited by Transformer; 06-08-2013 at 09:58 AM.
    Regards,

    Transformer

Similar Threads

  1. Access Query Help
    By Vipergs8v10 in forum Access Help
    Replies: 2
    Last Post: 05-08-2013, 06:32 PM
  2. VBA Procedure for nested if statement.
    By _google in forum Excel Help
    Replies: 1
    Last Post: 02-08-2013, 10:16 PM
  3. Dynamic Chart Query
    By leopaulc in forum Excel Help
    Replies: 6
    Last Post: 11-26-2012, 04:50 PM
  4. Replies: 2
    Last Post: 11-17-2011, 07:49 PM
  5. On Error Statement (Visual Basic)
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 10-12-2011, 09:06 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
  •