PLEASE HELP!!!!

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

Guest

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
 
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
 
Back
Top