On 13 Aug 2004 06:10:09 -0700, Pea wrote:
Hello,
I have an Access report that works well. I need to add a prompt for
the user to input the month of data that the report will show. I used
an InputBox and instead of showing that month in the report, it shows
all months in the table. And the InputBox is automatically populated
w/ the current month. Here is the command I used:
=InputBox("Enter Full Month and Year","Report
Month",Format$([USER_DATE],"mmmm yyyy",0,0))
any ideas what is wrong with this?
Create a query.
Include all the fields needed in the report.
Add a new column to the query grid.
GetMonth:Format([User_Date],"mm/yyyy")
As criteria parameter for this column write:
[Enter Month and Year mm/yyyy]
The month and year can be entered using 06/2004.
If you want the full written month name entered (which is unnecessary
for the result), change mm/yyyy to mmmm/yyyy in both the column
expression and inside the prompt brackets.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.