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

InputBox date prompt gives wrong month

P: n/a
Pea
Hello,
I have a nicely running report (thanks to Reggie and others) which
I've been asked to modify to prompt for the Month (a monthly report to
be run). I used an InputBox command:

=InputBox("Enter Full Month and Year","Report
Month",Format$([USER_DATE],"mmmm yyyy",0,0))

But this prompts with the date already filled in (August 2004). If I
change it to "July 2004", it shows the report with date header "July
2004" but the data under it is for August, then it shows July, June,
etc. Anyone know what's wrong w/ my command? I just want the user to
enter the month and year and have the report show that month only.

Thank you,
Tara
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Change the Query on which the report is based.

ta******@yahoo.com (Pea) wrote in message news:<f4**************************@posting.google. com>...
Hello,
I have a nicely running report (thanks to Reggie and others) which
I've been asked to modify to prompt for the Month (a monthly report to
be run). I used an InputBox command:

=InputBox("Enter Full Month and Year","Report
Month",Format$([USER_DATE],"mmmm yyyy",0,0))

But this prompts with the date already filled in (August 2004). If I
change it to "July 2004", it shows the report with date header "July
2004" but the data under it is for August, then it shows July, June,
etc. Anyone know what's wrong w/ my command? I just want the user to
enter the month and year and have the report show that month only.

Thank you,
Tara

Nov 13 '05 #2

P: n/a
Pea
It's just a report, there's no query running.
Tara

jo***********@gmail.com (Prasanna) wrote in message news:<6e**************************@posting.google. com>...
Change the Query on which the report is based.

ta******@yahoo.com (Pea) wrote in message news:<f4**************************@posting.google. com>...
Hello,
I have a nicely running report (thanks to Reggie and others) which
I've been asked to modify to prompt for the Month (a monthly report to
be run). I used an InputBox command:

=InputBox("Enter Full Month and Year","Report
Month",Format$([USER_DATE],"mmmm yyyy",0,0))

But this prompts with the date already filled in (August 2004). If I
change it to "July 2004", it shows the report with date header "July
2004" but the data under it is for August, then it shows July, June,
etc. Anyone know what's wrong w/ my command? I just want the user to
enter the month and year and have the report show that month only.

Thank you,
Tara

Nov 13 '05 #3

P: n/a
Pea
It's just a report, there's no query running.
Tara

jo***********@gmail.com (Prasanna) wrote in message news:<6e**************************@posting.google. com>...
Change the Query on which the report is based.

ta******@yahoo.com (Pea) wrote in message news:<f4**************************@posting.google. com>...
Hello,
I have a nicely running report (thanks to Reggie and others) which
I've been asked to modify to prompt for the Month (a monthly report to
be run). I used an InputBox command:

=InputBox("Enter Full Month and Year","Report
Month",Format$([USER_DATE],"mmmm yyyy",0,0))

But this prompts with the date already filled in (August 2004). If I
change it to "July 2004", it shows the report with date header "July
2004" but the data under it is for August, then it shows July, June,
etc. Anyone know what's wrong w/ my command? I just want the user to
enter the month and year and have the report show that month only.

Thank you,
Tara

Nov 13 '05 #4

P: n/a
A report is always based on DATA SOURCE, and DATA SOURCE is always a
query/table.
Just goto Report, open the DATA source property of the report, and
probably you will see the Query that is being used as data source.

Regards
Prasanna
ta******@yahoo.com (Pea) wrote in message news:<f4*************************@posting.google.c om>...
It's just a report, there's no query running.
Tara

jo***********@gmail.com (Prasanna) wrote in message news:<6e**************************@posting.google. com>...
Change the Query on which the report is based.

ta******@yahoo.com (Pea) wrote in message news:<f4**************************@posting.google. com>...
Hello,
I have a nicely running report (thanks to Reggie and others) which
I've been asked to modify to prompt for the Month (a monthly report to
be run). I used an InputBox command:

=InputBox("Enter Full Month and Year","Report
Month",Format$([USER_DATE],"mmmm yyyy",0,0))

But this prompts with the date already filled in (August 2004). If I
change it to "July 2004", it shows the report with date header "July
2004" but the data under it is for August, then it shows July, June,
etc. Anyone know what's wrong w/ my command? I just want the user to
enter the month and year and have the report show that month only.

Thank you,
Tara

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.