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
|
|||
|
|||
date error
I have a report which pulls info. onbasis of date range, using hasdata
property I am able to get a null value if there is not data processed within the date range, however in the header it gives a me a text "error" for the date range need have the date range mentioned, at the moment under the control source I use ="Dated from " & [Type beginning date] & " to " & [Type ending date] any help will be appreciated thanks |
#2
|
|||
|
|||
date error
You can't get the entered dates from parameter prompts if there are no
records returned. Either use the HasData to remove the error or replace all parameter prompts with references to controls on forms. This would work: ="Between " & [Forms]![frmRptCriteria]![txtStart] & " and " & [Forms]![frmRptCriteria]![txtEnd] -- Duane Hookom MS Access MVP "Gerald" wrote in message ... I have a report which pulls info. onbasis of date range, using hasdata property I am able to get a null value if there is not data processed within the date range, however in the header it gives a me a text "error" for the date range need have the date range mentioned, at the moment under the control source I use ="Dated from " & [Type beginning date] & " to " & [Type ending date] any help will be appreciated thanks |
#3
|
|||
|
|||
date error
let me try the later, however tried HasData option did not work. In control
source entered =IIf([Report].HasData,Sum([Count]),0)"Dated from " & [Type beginning date] & " to " & [Type ending date] thanks "Duane Hookom" wrote: You can't get the entered dates from parameter prompts if there are no records returned. Either use the HasData to remove the error or replace all parameter prompts with references to controls on forms. This would work: ="Between " & [Forms]![frmRptCriteria]![txtStart] & " and " & [Forms]![frmRptCriteria]![txtEnd] -- Duane Hookom MS Access MVP "Gerald" wrote in message ... I have a report which pulls info. onbasis of date range, using hasdata property I am able to get a null value if there is not data processed within the date range, however in the header it gives a me a text "error" for the date range need have the date range mentioned, at the moment under the control source I use ="Dated from " & [Type beginning date] & " to " & [Type ending date] any help will be appreciated thanks |
#4
|
|||
|
|||
date error
Your Sum() is correctly configured but you would have to use the same
IIf(HasData...) for your parameter prompts. Don't use parameter prompts. -- Duane Hookom MS Access MVP "Gerald" wrote in message ... let me try the later, however tried HasData option did not work. In control source entered =IIf([Report].HasData,Sum([Count]),0)"Dated from " & [Type beginning date] & " to " & [Type ending date] thanks "Duane Hookom" wrote: You can't get the entered dates from parameter prompts if there are no records returned. Either use the HasData to remove the error or replace all parameter prompts with references to controls on forms. This would work: ="Between " & [Forms]![frmRptCriteria]![txtStart] & " and " & [Forms]![frmRptCriteria]![txtEnd] -- Duane Hookom MS Access MVP "Gerald" wrote in message ... I have a report which pulls info. onbasis of date range, using hasdata property I am able to get a null value if there is not data processed within the date range, however in the header it gives a me a text "error" for the date range need have the date range mentioned, at the moment under the control source I use ="Dated from " & [Type beginning date] & " to " & [Type ending date] any help will be appreciated thanks |
Thread Tools | |
Display Modes | |
|
|