Re: Fromdate and Todate on Report
- From: "Kevin via AccessMonster.com" <u7122@uwe>
- Date: Mon, 26 Sep 2005 16:36:54 GMT
This Worked Perfectly!! Thanks Al..................
Kevin
Al Camp wrote:
>Kevin,
> Something odd here... if your FromDate and To Date values are on the
>form, you should be referring to them in the query and report as...
> Between Forms!frmYourForm![FromDate] And Forms!frmYourForm![ToDate])
>AND.....
>
> In the report header...
> = "From " & Forms!frmYourForm!FromDate & " to " &
>Forms!frmYourForm!ToDate
>should display the values from the form.
>
> Given the code you posted though, there's something bothering me about
>how you described the problem. I would have expected that after entering
>the 2 dates on the form, and clicking for the report, and since your query
>dates values are incorrectly referred to... I would have expected another 2
>prompts for the date before the report really came up.
> But... let's let that go for now... just try my references and see how it
>goes.
>hth
>Al Camp
>Candia Computer Consulting - Candia NH
>http://home.comcast.net/~cccsolutions
>
>>I have a form "frmReportPanel" where the user can pick a fromdate and
>>todate.
>[quoted text clipped - 33 lines]
>> Thanks,
>> Kevin
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200509/1
.
- Prev by Date: Re: How do I get an Access Report into Power Point?
- Next by Date: Re: interview report
- Previous by thread: Re: How do I get an Access Report into Power Point?
- Next by thread: Re: interview report
- Index(es):
Relevant Pages
|
