Update Query for a DATETIME range 1

[LeonelSanchezJr]

I run the query below, but only for a datetime range of
'05/23/01'. How can I do that?

UPDATE Callnotes SET cCallNotes = c.cCallNotes
FROM Callnotes a
INNER JOIN HelpDesk b
ON a.ID=b.icallnoteskey
INNER JOIN Hlpdsk_All c
ON b.cproblemnum=c.cproblemnum

 

[tlbroadbent]

Assuming the date appears on one of the tables just add the criteria in a Where clause.

UPDATE Callnotes SET cCallNotes = c.cCallNotes
FROM Callnotes a
INNER JOIN HelpDesk b
ON a.ID=b.icallnoteskey
INNER JOIN Hlpdsk_All c
ON b.cproblemnum=c.cproblemnum
Where a.date1 Between '05/23/01' And '05/23/01'

If the date is on a different table just change the reference (i.e., c.date1). Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.