date option sort

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
Click to expand...

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()
Click to expand...

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]
 
Back
Top