Group:  Microsoft Access ยป microsoft.public.access.reports
Thread: how do I show from and to dates on a report or week beginning

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

how do I show from and to dates on a report or week beginning
CB61 23.08.2006 12:51:02
I need to show week of .... on a report I have a parameter set up in the
query between start date and end date but can't get it to transfer to show
on the report
RE: how do I show from and to dates on a report or week beginning
Ofer Cohen 23.08.2006 13:05:02
Check this link on "How to Print Query Parameter values onto your report"

http://www.databasedev.co.uk/printing_parameters.html

Just to add to it, it will be enough to write in the control source of the
fields the name of the parameter, for example

="The week of " & [Enter Start Date] & " And " & [Enter End Date]


--
Good Luck
BS"D


"CB61" wrote:

[Quoted Text]
> I need to show week of .... on a report I have a parameter set up in the
> query between start date and end date but can't get it to transfer to show
> on the report
RE: how do I show from and to dates on a report or week beginning
CB61 23.08.2006 13:40:02
Thanks so much that worked perfectly - first time I have used this forum and
I shall come back again for sure - also as I'm a Brit it was good to get the
answer through a UK link . cheers!!!

"Ofer Cohen" wrote:

[Quoted Text]
> Check this link on "How to Print Query Parameter values onto your report"
>
> http://www.databasedev.co.uk/printing_parameters.html
>
> Just to add to it, it will be enough to write in the control source of the
> fields the name of the parameter, for example
>
> ="The week of " & [Enter Start Date] & " And " & [Enter End Date]
>
>
> --
> Good Luck
> BS"D
>
>
> "CB61" wrote:
>
> > I need to show week of .... on a report I have a parameter set up in the
> > query between start date and end date but can't get it to transfer to show
> > on the report

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net