#Error in Calculated control on my Report
in [Reports]
|
Prev: Access 2000 reducing query parameter prompts in reports
Next: Break data into two columns in subreport
From: Lori on 15 Jul 2008 14:59 I have a calculated control that returns an #Error when no records are found. I would like it to return the following message in the text box instead: "No Records Found." How can I accomplish this. Control Name: TotalVolume Control Source: =Sum([Volume])
From: Lori on 15 Jul 2008 15:33 Never mind. I found my solution. I replaced my Control Source to: =IIf([HasData],Sum([Volume]),"No Expiring FPA's.") Thanks anyway! "Lori" wrote: > I have a calculated control that returns an #Error when no records are found. > I would like it to return the following message in the text box instead: "No > Records Found." > > How can I accomplish this. > > Control Name: TotalVolume > Control Source: =Sum([Volume])
From: Bill - ESAI on 22 Jul 2008 13:05
what is the "HasData" variable set too?? Bill "Lori" <Lori(a)discussions.microsoft.com> wrote in message news:1F7446CA-43CB-4DB9-A9A5-0D1F19E64A18(a)microsoft.com... > Never mind. I found my solution. I replaced my Control Source to: > =IIf([HasData],Sum([Volume]),"No Expiring FPA's.") > > Thanks anyway! > > "Lori" wrote: > >> I have a calculated control that returns an #Error when no records are >> found. >> I would like it to return the following message in the text box instead: >> "No >> Records Found." >> >> How can I accomplish this. >> >> Control Name: TotalVolume >> Control Source: =Sum([Volume]) |