Search results

Alright, I am trying to get this database done for work and I am on a deadline. I have posted a few entries and have gotten a couple responses, but nothing that has worked. Please, if anyone knows how to get an #error message gone, let me know. The 2 fields are from subreports that sometimes...

Thanks for the sugestion, but I am still getting an error. I have it in there as: IIF(IsNull([Copy of Payments].[Report]![Text24]), "0",[Copy of Payments].[Report]![Text24]) Is there anything wrong with the way I have it? Let me know if you have any other suggestions. Billie

I know that this topic has been discussed, but I can not get my report to work. I have 2 text boxes that are giving me this message. I think that I should use the Nz function, but no matter what way I type it in, there is always an error message. I think it has to do with the fact that the...

Hello, I have been getting suggestions for the past few days about how to fix some mistakes in my report. I now, have 2 (Invoice and Payment) subreports in my major report. I am now trying to calculate fields from the 2 subreports to show in the project footer of my major report. I think that...

Hello, I was just wondering if there was a way to calculate through sub reports. I finally got my information from all three tables to show on the same report correctly. I did add 2 subreports to my report. Now, I need to take a number from my initial report and add that to a number in my...

Here is my problem. I have 3 tables that all are joined by a project name. THe information on the 3 tables is a developer, the project, and the address (Table 1), the invoices that are assigned to each project (Table 2), and any payments the developer has paid against the projects expenses...