Error Encountered while executing query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created the following query:

TRANSFORM Count(dbo_SALEDETL.DETL_INVOI) AS CountOfDETL_INVOI
SELECT NewReleaseMasterList.UPC, Count(dbo_SALEDETL.DETL_INVOI) AS CountOfDETL_INVOI1
FROM NewReleaseMasterList LEFT JOIN dbo_SALEDETL ON NewReleaseMasterList.UPC=dbo_SALEDETL.DETL_SKU
WHERE (((dbo_SALEDETL.DETL_STAT)="S") AND ((dbo_SALEDETL.DETL_COND)="U") AND ((dbo_SALEDETL.DETL_DATE)>=#12/29/2003#))
GROUP BY NewReleaseMasterList.UPC
ORDER BY NewReleaseMasterList.UPC
PIVOT dbo_SALEDETL.StoreID;

when the DETL_DATE criteria is included I receive the following message:
Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It appears you are using a SQL Server db, correct? If so SQL'r dbs
use different delimiters for a date value. Change

#12/29/2003#

to

'2003-12-29'

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBKytYechKqOuFEgEQILjACfbbcDerzsoXiKJA7BX+NxIMIFZdgAoLKO
e93muQxtG2guU6WWjxMiPDQK
=Zl8H
-----END PGP SIGNATURE-----
 
Back
Top