K Khalil Handal Jul 22, 2007 #1 Hi, Is there a tutorial about how to find certain records between 2 dates?
P pietlinden Jul 22, 2007 #2 Hi, Is there a tutorial about how to find certain records between 2 dates? Click to expand... SELECT ... FROM WHERE MyTable.SomeDate BETWEEN Date1 and Date2;
Hi, Is there a tutorial about how to find certain records between 2 dates? Click to expand... SELECT ... FROM WHERE MyTable.SomeDate BETWEEN Date1 and Date2;
K Khalil Handal Jul 22, 2007 #3 hi, I should put the dates manualy in this case. I was wondering if I can put the dates in an unbounded object in a form and see the records below?
hi, I should put the dates manualy in this case. I was wondering if I can put the dates in an unbounded object in a form and see the records below?
D Douglas J. Steele Jul 22, 2007 #4 You can refer to controls on a form as SELECT ... FROM WHERE MyTable.SomeDate BETWEEN Forms!NameOfForm!NameOfControl1 and Forms!NameOfForm!NameOfControll2;
You can refer to controls on a form as SELECT ... FROM WHERE MyTable.SomeDate BETWEEN Forms!NameOfForm!NameOfControl1 and Forms!NameOfForm!NameOfControll2;
K Khalil Handal Jul 22, 2007 #5 Thanks Doug, Douglas J. Steele said: You can refer to controls on a form as SELECT ... FROM WHERE MyTable.SomeDate BETWEEN Forms!NameOfForm!NameOfControl1 and Forms!NameOfForm!NameOfControll2; Click to expand...
Thanks Doug, Douglas J. Steele said: You can refer to controls on a form as SELECT ... FROM WHERE MyTable.SomeDate BETWEEN Forms!NameOfForm!NameOfControl1 and Forms!NameOfForm!NameOfControll2; Click to expand...
