I have tried to crate field which is equal to: =+ I have received #error. Source for second field in formula is from sub report: = Where is my mistake?

I'm trying to show a total count of the records in a report. In the report footer I have the function "=Count()" where pmocid is a field in the report...

I have used the following statements in a report: =IIf("#Error",0,) =IIf(="#Error",0,) =nz(, 0) The report will show #Error if there is no data for the...

Hi I'm trying to add 4 fields together representing positive pregnancy test results by trimester along with the old field. The addition looks...

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...

I have a report that is based on a query. At the end of this reprt I would like to have a count based on certain criteria. I am trying to use the DCount...

I have a report that consolidates data from two tables -- The main table carries two keys pointing to two records in another table. The query is written and...

Hello, On an report, I get an "#Error" in the text box control who's Control Source is set to this expression. =Sum(IIf(!=1 And (!='G' Or !='G' Or !='H'...

Dear all, I am having error when running the sum e.g. =Sum() , the value of will be 0 or null. I tried: sum(Nz(,0)) and Nz(sum(),0) , but both still got...

I get this in Text Fields that do not have data to report. I have found solutions for Calculated Fields. Is there another solution for Text Fields? Thanks!

I am getting this in Text fields that have no data to report. I did a search here and found solutions for Calculated fields. Is there a different solution for...

I am creating a report and want to count the number of records in the report. The data for the report is coming from a parameter query. I have tried putting...

I designed a customer account satement report. In this report for some customers there is no data for calcualtion in certain period. So I am getting #Error as...

Hi there, I get this error when there is no data to display in two different areas: 1) Where the sum and grand totals would be 2)The report requires the...

Hi all; I have the following iif statements to get data for Name & address. First, it looks to see if there is a new name & address, if there isn't, it gets...

I have designed an application in which the user has to export a report to a snp file to email users of the report. Recently a snap shot showed a #Error in...

When I want to print a blank copy of a Report so that I may fill it out manually, I get a #Error on the text box that was expecting a value. This is the...

Hi, I have developed a report where I have some aggregation functions at the footer of each group. Evereything works OK when there is data (in the report)....

I've create a simple record based to a query with a Total Field to summarize my expenses. The record work with a range of date. If in the range of the date no...

I am getting an #Error in my Footer total for three sub reports in this section when data is null in one or more of my three fields. I have it set up...