Najm,
You can quickly do this using Terry's exellent answer or if you're going
to do it on many reports and forms, I set it up like this ...
- Create a new Form called [frmGetDates]
- Create two unbound controls on it called [dteFrom] and [dteTo]
- Add an "OK" Commmand Button to the form
- Code behind the button to
- make frmGetDates invisible (but still open)
- Open the Report
- Use the criteria for opening the form as (aircode)
WHERE [MyDateField] Between Forms![frmGetDates]![dteFrom] and
Forms![frmGetDates]![dteTo]
Once you have this form set up, you can use it all the time. You can
even use a tabbed form combo box under the command button to select from
your list of reports of forms if you want to get that fancy.
I tend not to set the criteria under the command button but rather in
the query for the form or report which is the same as what Terry was
suggesting except that it looks at the form rather than asks you to
input them in a dialog box. In the Query you put
>=Forms![frmGetDates]![dteFrom] and <=Forms![frmGetDates]![dteTo]
Brett
najbaan wrote:
> Dear friends,
>
> I would like to get your help to make reports by weekly /monthly/ from
> a specific date to another specific date using ms acces database
>
> regards
>
> Najm
>
>
--
Brett Collings
Strengthening Families Administrator
D2D 46422
DDI (04) 916 3422
-------------------------------
This email message and any attachment(s) is intended only for the
person(s) or entity(entities) to whom it is addressed. The
information it contains may be classified as IN CONFIDENCE and may be
legally privileged. If you are not the intended recipient any use,
disclosure or copying of the message or attachment(s) is strictly
prohibited. If you have received this message in error please
notify us immediately and destroy it and any attachment(s).
Thank you. The Ministry of Social Development accepts no
responsibility for changes made to this message or to any
attachment(s) after transmission from the Ministry.
-------------------------------
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Great things are happening at Yahoo! Groups. See the new email design.
http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
