Lettronics Support

The place for free support for our software and systems.
Welcome to Lettronics Support Sign in | Join | Help
in Search

Syntax Error

Last post 04-29-2009, 2:57 PM by lawlor. 2 replies.
Sort Posts: Previous Next
  •  04-29-2009, 10:54 AM 1063

    Syntax Error

    Hi ,

    Having finally sorted out my till and most other issues i have just been playing around with reports but under the more reports page i tried the 5yr chart of sales by month for category and i get the following error

    Run-time error '-2147217900 (80040e14)':

     

    Syntax error (missing operator) in query expression 'RecieptDetails.RecieptID = reciepts.RecieptID INNER JOIN Products ON RecieptDetails.ProductID = Products.ProductID'.

     not that these reports are massivly important but they might be useful.

    Cheers

    Ben 

  •  04-29-2009, 2:45 PM 1064 in reply to 1063

    Re: Syntax Error

    Is that the full error message Tongue Tied

    Looks like that SQL is incomplete?


    Get free EPoS software at http://www.lettronics.com
  •  04-29-2009, 2:57 PM 1065 in reply to 1064

    Re: Syntax Error

    hi,

    Yeah thats the full error message....

    Ben 

View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems