Error in select statement

Results 1 to 2 of 2

Thread: Error in select statement

  1. #1
    Join Date
    Dec 1969

    Default Error in select statement

    I keep getting the following error:<BR><BR>Syntax error in date in query expression &#039;(((MA_QualitySheet.Date) Like #2/*/2001#))&#039;.<BR><BR>any reason why?? what is missing. Help, please?

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Error in select statement

    You cannot use a * in your date it has to be a valid date<BR><BR>if you want to select for a month then use the month and year function and even the datepart function and get the information

Posting Permissions

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