By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

Report parameter not working

P: n/a
Pea
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?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.