[AccessD] Citing entered data range on report

John Clark John.Clark at niagaracounty.com
Wed May 29 13:16:14 CDT 2013


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.


More information about the AccessD mailing list