date option sort

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy - 03 Mar 2005 10:05 GMT

i got a table with the fields: Week Code, Start date, End date
the table keeps a forecast, sow today i forecast for 3 mouth later..
what i want now is: when opening the forms, go to week code where date() is
inside "start date" and "finish date", sow i can view current week.
do you know how to do it in basic code(or any other way).
P.S.: i don't want a form with 1 record only, sow can't use any query.

thanks

Reply to this Message

John Vinson - 03 Mar 2005 18:13 GMT

>i got a table with the fields: Week Code, Start date, End date
>the table keeps a forecast, sow today i forecast for 3 mouth later..
>what i want now is: when opening the forms, go to week code where date() is
>inside "start date" and "finish date", sow i can view current week.
>do you know how to do it in basic code(or any other way).
>P.S.: i don't want a form with 1 record only, sow can't use any query.

You can and should use a query; if you assume that doing so gives you
a form with only one record, that assumption is simply incorrect. A
query can return zero records, one record, 23,319,427 records or as
many records as exist in the table.

Base the Form on a Query with a criterion of

>= Date()

on [Start Date]

and

<= Date()

on [End Date]. If there are a dozen records in that range, you'll see
all of them in the form.

John W. Vinson[MVP]

Reply to this Message