William Benson
vbacreations at gmail.com
Sun Jun 2 07:51:43 CDT 2013
You might want to group the report by quarter and year (I would) so you need not only begin/end but also period begin, period end. On May 29, 2013 5:43 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote: > Charlotte's "two expressions in the query" is the simplest way to go based > on your current > paramter input method, but I'd go with a simple form that captures the > start and end dates > instead - it is extensible in future if you want a choice of reports or > the option to view/print > preview/print the report. > > In the second situtation, I don't pass the dates as OpenArgs, I create a > couple of status > functions which are set in the code which calls the report use and are > used as sriterai in the > the query. > > -- > Stuart > > > On 29 May 2013 at 11:22, Charlotte Foust wrote: > > > You could return the parameters in the query by creating an expression > > field for each. That would allow you to see it in the report, but I > prefer > > to capture start and end dates in the form that selects the report and > pass > > it into the report in OpenArgs. > > > > Charlotte > > > > On Wed, May 29, 2013 at 11:16 AM, John Clark > > <John.Clark at niagaracounty.com>wrote: > > > > > I am creating this report for our DA's office, that let's them enter a > > > start date and an ending date, and it shows all witness fees & mileage > paid > > > out for that range, with a total at the end. What I do not have > > > though...and maybe I'm just having a brain-dead moment here...is the > range > > > that it covers. I'd like it to list the range somewhere on the report. > > > > > > Now, I did this the quick and easy way and had it based on a query, > and it > > > is in that query that I placed the spot for date entries, by putting > the > > > code, ">=[StartDate] And <=[EndDate]" in the date field. Is there a > way to > > > use this entered info, or do I need to create an input form and have > the > > > dates entered there? > > > > > > Notice: This electronic transmission is intended for the sole use of > the > > > individual or entity to which it is addressed and may contain > confidential, > > > privileged or otherwise legally protected information. If you are not > the > > > intended recipient, or if you believe you are not the intended > recipient, > > > you are hereby notified that any use, disclosure, copying, > distribution, or > > > the taking of any action in reliance on the contents of this > information, > > > is strictly prohibited. Niagara County is not responsible for the > content > > > of any external hyperlink referenced in this email or any email. > > > IF YOU HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE > SENDER > > > IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY > PAPER > > > OR ELECTRONIC COPIES. > > > Thank you for your cooperation. > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >