With Igor's help, I have this SQL statement that pulls out records based on a start and stop date.
"SELECT Year, Month, Day, Open, High, Low, Close FROM [" & gsTableName & "] " & _ "WHERE ((Month - " & lngStartMth & ")*100 + (Day - " & lngStartDay & ") + 1300) % 1300 <= ((" & _ lngEndMth - lngStartMth & ") * 100 + (" & lngEndDay - lngStartDay & ") + 1300) % 1300 " & _ "ORDER BY Year, ((Month - " & lngStartMth & ")*100 + (Day - " & lngStartDay & ") + 1300) % 1300" It worked well, except I added the 'Year' to the ORDER BY so that I could get the information in this format: (Example: 10/1 to 4/1) 1988 10 01 <data> 1988 10 02 <data> ...crossing the end of the year... ...into the next year... 1989 03 29 <data> 1989 03 30 <data> 1989 03 31 <data> 1989 04 01 <data> ...starting the next 10/01 to 04/01 extraction... 1989 10 01 <data> 1989 10 02 <data> ... ... ...and so forth. Problem is that by adding the 'Year' to ORDER BY, while it does in fact give me the above format, it also includes info I don't need. For example, when it started at 10/01 for 1988 and ended the year, it then continued to 04/01 within the same 1988 year! Any suggestions? Thanks. Rick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users