Search results for query: *

Never mind, I'm an idiot. Forgot to add the markup, =NZ([Sum Of matcost]*1.15),0) Thanks for your help!!!

Thanks for the help, I was on a similiar track using IIf. Like this: =IIf(IsNull([Sum Of matcost]),0,[Sum Of matcost])) Which I then changed to: =NZ([Sum Of matcost],0) While testing this functionality, I noticed a troubling thing: Neither returns the same value as the total already...

I have a report that calculates a total for all jobs by job. When a value is null (or maybe even negative??) the total fails to show a value. When all the numbers in the total are available, the number is calculated correctly. I have checked the values that would go into that total, and a valid...

Thanks so much for your patient help. I am such a noobie. In the end, what I did was write a query that picks out wpno and totals the price for each. I then call that value from the main recordsource for the report. (Just like you said, I was just doing it wrong.) For text boxes where I need to...

That's what I thought! I joined the wpno fields in Relationships, but there is no line between between the two tables in the query. What in the world is wrong with me!@

You're right. That didn't work.But it seems like I ought to be able to write a query that sums the value I need and then stick that value in the text box. I'm quite new at this, but it seems like such a simple thing to do. The problem I have is that the report doesn't know which line of data...

The main report has the following sections: Report Header Page Header wpno Header itemno Header Detail itemno Footer wpno Footer Page Footer Report Footer Which section of the main report contains the subreport? wpno Footer Which section of the main report contains the text box? wpno Header...

I have a report which has too many values to be handled by one query. So I created another report using a different query and inserted it as a subreport. I then total one of those fields and that part works fine. However when I try to set an object in the main report to =Sum(Reports!pg3!price)...

Yes I can. Thanks in advance... WorkPackMain - Main Table ID - Autonumber field generated by ACCESS wpno - Work Pack # (Project) itemno - item # (multiple items per project) RatesandHours - Table of technical workers and their payrate ID wpno itemno discipline - type of worker hours - # of...

I have a dataset that is a group of projects completed by a construction firm. Each is a separate project. Within each project, a number of items are installed. Within those items, there are technical hours to be billed, components to be fabricated and installed, and logistical elements such as...