Trilochan Sahu Trilochan Sahu - 1 year ago 92
SQL Question

MS access between clause not Working

MS access between clause not Working(between 2 dates).

My query is below:

SELECT [Supplier].sname,
FROM Purchase
ON Purchase.suppid = Supplier.sid
WHERE [Purchase].date BETWEEN date= ? AND ?

Answer Source

WHERE [Purchase].date BETWEEN date= ? AND ? is not valid syntax. Try:

WHERE   [Purchase].date BETWEEN ? AND ?
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download