text box of date range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to have a text box on a report that shows the month from the
date range of the query that the report is based on? For example, I have a
query that shows totals per country based on a date range (ex: between
11/01/2005 and 11/30/2005). I want the text box on the report to show
November for the date range, or whatever the month name is for the range
specified.
 
Sure. For a quick and dirty, just have the Control Source of the text box as
follows:

=Format(NameOfDateFieldInQuery, "mmmm")

See the Format() function in the Help file for details.

HTH
 
If you are using a parameter for the dates (such as a StartDate and
EndDate), you can put a text box on the report and set these properties:
Control Source =[StartDate]
Format mmmm
 
BOTH SOLUTIONS WORK GREAT, THANKS

Allen Browne said:
If you are using a parameter for the dates (such as a StartDate and
EndDate), you can put a text box on the report and set these properties:
Control Source =[StartDate]
Format mmmm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ann said:
Is there any way to have a text box on a report that shows the month from
the
date range of the query that the report is based on? For example, I have a
query that shows totals per country based on a date range (ex: between
11/01/2005 and 11/30/2005). I want the text box on the report to show
November for the date range, or whatever the month name is for the range
specified.
Click to expand...
Click to expand...
 
Back
Top