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
|