Date Range in Header
in [Reports]
|
From: lburgoyne on 6 Apr 2010 14:47 I have a report that is based on a query that is using text fields from a form as begin date and end date parameters. This all works well. What I am trying to do is put a date range in the header of the report to reflect the values in the underlying query. Any ideas? Lou Burgoyne Keeper of the odd jobs. --- frmsrcurl: http://msgroups.net/microsoft.public.access.reports/
From: John Spencer on 6 Apr 2010 15:22 You should be able to reference the controls on the form just as you reference them in the query. In a text control, set the source to =Forms!NameOfForm!NameOfControl You can use the format function to format the dates, so you might end up with = "FROM " & Format(Forms![MyParameterForm]![StartDate],"DD MMM YYYY") & " TO " & Format(Forms![MyParameterForm]![EndDate],"DD MMM YYYY") John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County lburgoyne wrote: > I have a report that is based on a query that is using text fields from a form as begin date and end date parameters. > > This all works well. > > What I am trying to do is put a date range in the header of the report to reflect the values in the underlying query. Any ideas? > > Lou Burgoyne > Keeper of the odd jobs. > > --- > frmsrcurl: http://msgroups.net/microsoft.public.access.reports/
From: KARL DEWEY on 6 Apr 2010 16:55 One way is to copy the criteria elements and paste as a calculated field in the query. -- Build a little, test a little. "lburgoyne" wrote: > I have a report that is based on a query that is using text fields from a form as begin date and end date parameters. > > This all works well. > > What I am trying to do is put a date range in the header of the report to reflect the values in the underlying query. Any ideas? > > Lou Burgoyne > Keeper of the odd jobs. > > --- > frmsrcurl: http://msgroups.net/microsoft.public.access.reports/ > . >
|
Pages: 1 Prev: Report Headers/Design Next: multiple selection in report |