Stuart McLachlan
stuart at lexacorp.com.pg
Wed May 29 16:42:01 CDT 2013
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 >