If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing date range on Report
I am running a report based on a query using the date selection criteria,
BETWEEN ---- AND-----. Is there any way of printing this date range in the header of the report. I would also like to take the totals from this query and put them into a table using the date range as an identifier, is this possible? |
#2
|
|||
|
|||
Printing date range on Report
Are the dates picked up as parameters (either prompting the user to enter
them, or referring to controls on an open form, or set in code)? Simply put the name of the parameter as part of the ControlSource for a text box: ="This report for data between " & [Start Date:] & " and " & [End Date:] -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Fritz" wrote in message news I am running a report based on a query using the date selection criteria, BETWEEN ---- AND-----. Is there any way of printing this date range in the header of the report. I would also like to take the totals from this query and put them into a table using the date range as an identifier, is this possible? |
#3
|
|||
|
|||
Printing date range on Report
Hi Douglas
When the report is run the user is prompted to enter the date range required. This date range is linked to one field, 'Date of Claim'. Hope that makes sense? "Douglas J. Steele" wrote: Are the dates picked up as parameters (either prompting the user to enter them, or referring to controls on an open form, or set in code)? Simply put the name of the parameter as part of the ControlSource for a text box: ="This report for data between " & [Start Date:] & " and " & [End Date:] -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Fritz" wrote in message news I am running a report based on a query using the date selection criteria, BETWEEN ---- AND-----. Is there any way of printing this date range in the header of the report. I would also like to take the totals from this query and put them into a table using the date range as an identifier, is this possible? |
#4
|
|||
|
|||
Printing date range on Report
="Claims for Period " & Format$([Enter Beginning Date],"mmmm d"", ""yyyy") &
" through " & Format$([Enter Ending Date],"mmmm d"", ""yyyy") The prompts from the query and those in the above text box need to be exact. Otherwise the user will be prompted twice. "Fritz" wrote: Hi Douglas When the report is run the user is prompted to enter the date range required. This date range is linked to one field, 'Date of Claim'. Hope that makes sense? "Douglas J. Steele" wrote: Are the dates picked up as parameters (either prompting the user to enter them, or referring to controls on an open form, or set in code)? Simply put the name of the parameter as part of the ControlSource for a text box: ="This report for data between " & [Start Date:] & " and " & [End Date:] -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Fritz" wrote in message news I am running a report based on a query using the date selection criteria, BETWEEN ---- AND-----. Is there any way of printing this date range in the header of the report. I would also like to take the totals from this query and put them into a table using the date range as an identifier, is this possible? |
#5
|
|||
|
|||
Printing date range on Report
On Aug 4, 1:04 am, Fritz wrote:
I am running a report based on a query using the date selection criteria, BETWEEN ---- AND-----. Is there any way of printing this date range in the header of the report. I would also like to take the totals from this query and put them into a table using the date range as an identifier, is this possible? I am rather using form to set dates from-to and then on report I am using "= forms!frmFilter!fldDateFrom" and "= forms!frmFilter! fldDateTo" to retrieve those values and print them in Header. You can set filter to query in the same way using above. To use same query as record source to create table, just save a copy of query and change it to Create Table Query. Regards, Branislav Mihaljev |
Thread Tools | |
Display Modes | |
|
|