PLEASE HELP!!!!

P

PS

I am trying to create a report that will allow my boss to open a report and
the current Month Name will show in the report instead of a numerical value.

I would also like him to key in a date range to review information within
the date he has keyed.
for example if he want to see date from 12/01/05 to 2/16/05 he can key in
this information and it will show the data.

Can someone please help me with this

Thank you very much in advance
 
A

Al Camp

PS,
First, in the query behind your report, place this criteria against the
appropriate Date field.
Between [Enter Start Date] and [Enter Start Date]
When the report runs, the user will be prompted to enter a Startdate and
End Date, which will be used to filter the records returned by the report.
[Enter Start Date] and [Enter Start Date] are parameters that also can
be used on your report to represent what the user enetered in response to
the 2 prompts.

Second...
Ex. User's Start Date entry might be 3/15/06
On your report, an unbound calculated text control with a ControlSource
of...
= Format([Enter Start Date], "mmmm")
would display as...
March
Probably you'll want this though...
= Format([Enter Start Date], "mmmm yy")
displays as...
March 06
 
Top