Looking up by dates in a range

[BigBlueMan]

I have a database of activities that take place between a start date and an
end date.

How do I arrange a query so that I can get all the activities that take
place BETWEEN two dates? (ie.. Say I want a report from January 1 thru
June 30. It might include an item that starts on February 1, and ends March
15)

If I put in 01/01/04 as the start, it is an absolute and would not pick up
this event.

Thanks!

ed

 

[Anno v. Heimburg]

How do I arrange a query so that I can get all the activities that take
place BETWEEN two dates? (ie.. Say I want a report from January 1 thru
June 30. It might include an item that starts on February 1, and ends
March 15)

What prohibits you from using something like "queryStart <= startDate AND
endDate >= queryEnd"?

Anno.

 

[BigBlueMan]

Lack of knowledge! ;-)

Thanks, I'll try it!

ed

 

[BigBlueMan]

Thanks! Went into the SQL view and added the '<' and '>' signs and it works
like a charm!
ed