Charlotte Foust
charlotte.foust at gmail.com
Wed May 29 13:22:15 CDT 2013
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 > >