MS Acces Query Help needed

[tanvirtonu]

Can anybody tell me whats wrong with my MsAcces SQL given below.The error says- Syntax error[missing operator] in where clause

SELECT
     SalesInvoice.`SalesDate` AS SalesInvoice_SalesDate,
     SalesInvoice.`ID` AS SalesInvoice_ID,
     UniteSalse.`ID` AS UniteSalse_ID,
     Unit.`Garage` AS Unit_Garage,
     SalesInvoice.`TotalAmount` AS SalesInvoice_TotalAmount,
     SalesInvoice.`Commission` AS SalesInvoice_Commission,
     SalesInvoice.`Paid` AS SalesInvoice_Paid,
     SalesInvoice.`Due` AS SalesInvoice_Due
FROM
     `SalesInvoice` SalesInvoice,
     `UniteSalse` UniteSalse,
     `Unit` Unit
WHERE SalesInvoice.ID = UniteSalse.SalesInvoiceID
AND UniteSalse.ID = Unit.ID
AND SalesInvoice.SalesDate BEWEEN #1/2/2008 AND #1/2/2008#

 

[Kiwiman]

Howzit

THere is this...

AND SalesInvoice.SalesDate [b]BEWEEN[/b] #1/2/2008 AND #1/2/2008#

it should be

AND SalesInvoice.SalesDate [b]BETWEEN[/b] #1/2/2008 AND #1/2/2008#

 

[raskew]

Re: MS Access Query Help needed

Dates need to be surrounded by ## (both sides).

AND SalesInvoice.SalesDate BETWEEN #1/2/2008[COLOR="Red"]#[/COLOR] AND #1/2/2008#

HTH - Bob