Here is a criteria how I open my recordset:
criteria = "SELECT [Date], [Time], " + MyField + " FROM " + MyDB + " WHERE Time >='" + StartTime + "' AND Time <='" + EndTime + "' AND Date =#" + MyDate + "#"
I would like to add there one variable called Step.
I mean that if there is field in my database for every 1 minutes and I wanna open recordset only for every 15 minutes (Step is 15 minutes).
Is this even possible?? If it is, would you give me an example!
Thanks in advance!