[AccessD] Citing entered data range on report

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
>
>


More information about the AccessD mailing list