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 4 5293
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: BlackFireNova |
last post by:
Using Access 2002
I am writing a report which draws data from several different tables. I
can't link all the tables in a query, as some can not be related without
truncating the data. I plan...
|
by: lisa.moffitt |
last post by:
How can I create a field in a view that takes a date field and
converts it to a month?
For instance, if I have a field called "CreatedOn" with a date of
'2/22/2007', how can I create another field...
|
by: gngui |
last post by:
i have a query that subtracts the date of birth (dob) from the date, i.e.
age_d: Date()-
This is OK as it gives me the difference in days e.g. 700 days. i would like the result to show me the age...
|
by: =?Utf-8?B?RmFlc3NsZXIgR2lsbGVz?= |
last post by:
Hello,
I'm facing a strange problem. We have an Asp.net 2.0 Web Application and
somehow the date format is changing from one client to another even if all
the code is running server-side...
...
|
by: valve2nd |
last post by:
This is probably a bonehead question, but I can't make it work. I want to prompt the user for a single date and select all records with a date falling within the week prior.
Obviously this works:...
|
by: agtsrbt |
last post by:
I'm just beginning to use SQL for MS Queries in Excel and am having difficulty with how to imput the date into a prompt.
I've used prompts for other fields and they seem to work fine, however,...
|
by: Tommaccoy |
last post by:
I have a table in which a "short Date" is entered. When I make a pivot table out of this table I want just the Month be displayed. How can this be donne?
PivotTable
Person Date
A ...
|
by: Sinclair |
last post by:
Hi Guys, just signed up and hope someone may be able to help. Have a "Tomorrow" button on my website which pulls data from MySQL, this then displays a list of jobs loaded for the following day -...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |