dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil Handal - 22 Jul 2007 18:36 GMT

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

Reply to this Message

pietlinden@hotmail.com - 22 Jul 2007 18:58 GMT

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

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

Reply to this Message

Khalil Handal - 22 Jul 2007 19:11 GMT

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,
>> Is there a tutorial about how to find certain records between 2 dates?
>
> SELECT ...
> FROM
> WHERE MyTable.SomeDate BETWEEN Date1 and Date2;

Reply to this Message

Douglas J. Steele - 22 Jul 2007 21:55 GMT

You can refer to controls on a form as

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> hi,
> I should put the dates manualy in this case.
[quoted text clipped - 7 lines]
>> FROM
>> WHERE MyTable.SomeDate BETWEEN Date1 and Date2;

Reply to this Message

Khalil Handal - 22 Jul 2007 23:51 GMT

Thanks Doug,

> You can refer to controls on a form as
>
[quoted text clipped - 14 lines]
>>> FROM
>>> WHERE MyTable.SomeDate BETWEEN Date1 and Date2;

Reply to this Message