dates

[Khalil Handal]

Hi,
Is there a tutorial about how to find certain records between 2 dates?

 

[pietlinden]

Hi,
Is there a tutorial about how to find certain records between 2 dates?

SELECT ...
FROM
WHERE MyTable.SomeDate BETWEEN Date1 and Date2;

 

[Khalil Handal]

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?

 

[Douglas J. Steele]

You can refer to controls on a form as

SELECT ...
FROM
WHERE MyTable.SomeDate BETWEEN Forms!NameOfForm!NameOfControl1 and
Forms!NameOfForm!NameOfControll2;

 

[Khalil Handal]

Thanks Doug,

You can refer to controls on a form as

SELECT ...
FROM
WHERE MyTable.SomeDate BETWEEN Forms!NameOfForm!NameOfControl1 and
Forms!NameOfForm!NameOfControll2;