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
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@sh163.net> 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