+ Reply to Thread
Results 1 to 2 of 2

Syntax error with simple MS Query

  1. #1
    Registered User
    Join Date
    06-02-2012
    Location
    texas
    MS-Off Ver
    Excel 2007
    Posts
    5

    Syntax error with simple MS Query

    Good afternoon all. I am making a simple query in MS Query where I select a check field and vendor field. When I drag the vendor field or any other field for that matter into the grid it works fine, but when I drag the check field into the grid I get this error message below. It's the <<???>> and the last line of the error window says Syntax Error. Also, I am not typing the SQL statements in directly, MS Query is generating them. I'm thinking maybe somehow a check# entered into the check field got corrupt and it's blowing up? Any help is very much appreciated. Thanks.

    SELECT MASTER_PAYMENT.Vendor, MASTER_PAYMENT.Check<<???>>
    FROM C:\Timberline\MASTER_PAYMENT
    Syntax Error

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Syntax error with simple MS Query

    I've found that MS-Query doesn't like some punctuation in its field headers "#" might be one of them.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Syntax error (Missing operator) in query expression
    By lengwer in forum Access Tables & Databases
    Replies: 2
    Last Post: 08-22-2013, 04:00 PM
  2. Syntax Error in Query Expression
    By acmagyar in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2013, 03:11 PM
  3. Simple VBA returning syntax error
    By BearLovesLuna in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2013, 05:09 PM
  4. Syntax Error (missing Operator) in query expression
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2011, 11:59 AM
  5. [SOLVED] Excel 2007 MS Query prompt yields Syntax error
    By Bruce in forum Excel General
    Replies: 0
    Last Post: 05-26-2006, 06:10 AM
  6. MS Query import from Excel - Syntax Error
    By EstherJ in forum Excel General
    Replies: 1
    Last Post: 04-24-2006, 04:44 AM
  7. Syntax Error in Excel Query for DATE field
    By James T in forum Excel General
    Replies: 3
    Last Post: 08-31-2005, 08:05 AM
  8. [SOLVED] Syntax error (missing operator) in query expression '6 Wescott Rd#
    By shealy in forum Excel General
    Replies: 0
    Last Post: 06-09-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1