Senin, 21 Mei 2012

[AccessDevelopers] Re: query

 

Thank you, Deanna.

Regards, jay lim

--- In AccessDevelopers@yahoogroups.com, Deanna Scheffe <deanna.scheffe@...> wrote:
>
> You can have a form come up and enter the date in the form. You can then
> reference the field from the form in all your queries. Below is code you
> can use in a report if you want your report to run between a start and
> ending date.
>
>
> =Forms![Form Name]!StartDate & " - " & Forms![Form Name]!EndDate
>
>
> Deanna Scheffe
> 940-592-2111 Ext. 306
> *"A man sees in the world what he carries in his heart." -Opening Scene of
> Faust*
>
>
> On Mon, May 21, 2012 at 8:40 AM, Jay <jaykay@...> wrote:
>
> > **
> >
> >
> > I had a few queries for information on tbl_transactions based on certain
> > date. Is there a way to have this date keyed once and allow the queries to
> > obtain this date, instead of opening up each query and make the change in
> > the criteria box?
> >
> > Regards, jay lim
> >
> >
> >
>

__._,_.___
Recent Activity:

Please zip all files prior to uploading to Files section.
.

__,_._,___

Tidak ada komentar:

Posting Komentar