Duane, ignore my earlier email. It works. My mistake for not having the date format in Field2 same as Transaction Date.
Again, thank you and others for helping me out.
Regards, jay
--- In AccessDevelopers@yahoogroups.com, "Jay" <jaykay@...> wrote:
>
> Duane, thank you for highlighting the criteria.
>
> Regards, jay lim
>
>
> --- In AccessDevelopers@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> >
> >
> > Deanna welcome to the group.
> >
> > The actual criteria for between would be:
> > Between Forms![Form Name]!StartDate And Forms![Form Name]!EndDate
> > Your expression can be used to display the date range in a text box in the report.
> >
> > There are some additional challenges if your date format is not m/d/y. Allen Browne has a good page regarding this at http://www.allenbrowne.com/ser-36.html.
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> >
> > To: AccessDevelopers@yahoogroups.com
> > From: deanna.scheffe@
> > Date: Mon, 21 May 2012 08:42:51 -0500
> > Subject: Re: [AccessDevelopers] query
> >
> >
> >
> >
> >
> > 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
> >
>
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar