help debug sql

[ecalbert]

SELECT fundprograms.*,fundprograms.id as fundprogramid, geographic.geoeng, geographic.geoheb, fundprograms.geographicid, fundprograms.deadline FROM fundprograms LEFT JOIN geographic ON fundprograms.geographicid = geographic.ID where ((fundprograms.deadline) between #3/1/2005# And #6/30/2005# or (fundprograms.deadline) is null)


For some reason programs are coming up with a deadline in July. - Why?

this is a query in Access

 

[ecalbert]

forget it! I fixed it -- it was a typo!! I meant to see 4 and typed 3.

 

[PHV]

And this ?
SELECT fundprograms.*, geographic.geoeng, geographic.geoheb
FROM fundprograms LEFT JOIN geographic ON fundprograms.geographicid = geographic.ID
WHERE fundprograms.deadline Is Null Or (fundprograms.deadline Between #3/1/2005# And #6/30/2005#);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244