RE: AW: SQL Date Range Problem with Between

Due to the date being created as three fields Year, Month and Day in
the table (pre. 1990 era ), concatenating the date fields does not help.
and it's becoming more complex because of the day values. So I
decided to run the query seperately  if the month/Year has changed and
that works.It  uses the same open data path.

Unless the rules for arithmetic have changed since I was in school
(possible, I suppose) field concatenation - done properly - must help. Did
you try any of the methods you were sent?

First I will get the Total for July 14 thru 31; cald Between 14 and
31 and then run again for Aug 1 thru 10; cald between 1 and 14;
Of course, CALM will be between 07 and 07 and 08 and 08, respectively.

Why would you use BETWEEN for CALM being between one value? Why not CALM =
value instead? But your suggestion should also work, and performance should
be tested against both forms of concatenation.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
If voting changed anything, they'd make it illegal.