Search results

I need to try to make the following logic work in a report: IF([CashAmt] >0 and [MiscTotal] and [ReTotal] and [DiTotal] and [GasTotal] = 0 then [CshOnTranFee]else [FuFee]) To sumarize, I have want to display one fee if any of the total fields have a value in them and I want to display another...

I have 4 fields on a report. [Field1], [Field2],[Field3], and {Field4}. I also have two fee fields. [Fee1], and [Fee2]. I need some logic to state that if Field1, 2, and 3 are all 0, then add [Fee1]. If either field 1,2,or 3 have any value other then 0, add [Fee2]. The point is that on a...

I thought about that. But I really want to stay away from using a form. The warehouse will not be running Access, therefore they must have the report in Excel or Word. I believe there is a way to compile the Access report to include the neccessary elements for a p.c. to use a form without having...

I have a report that generates order numbers. I am sending this report from Access to the warehouse so they can fill the orders and plug in the tracking numbers and ship date. I want the warehouse to only have access to the Tracking number and Ship date fields. As of now, they can change and...

Mel, My report is based on a Query instead of a Form. I tried your logic in a text box on my report anyway, but it gave me "Syntax error(comma)in query expresion" message. Thank you for trying. Any more suggestions?

I have a field in a report that I am trying to calculate another field from. I am trying for "If [Field Name] > 500 then [Field Name] - 250 ElseIf [Field Name]< 500 then [Field Name] /2" I have worked it several different ways and keep comming up with an error. Any suggestions?

I tried it as "Nz(SumOfXtns,0)" within my subreport and "=Nz([Reports]![FM Analysis A Query subreport]![Text18],0)+Nz([Reports]![FM Analysis B Query subreport]![Text14],0)+Nz([Reports]![FM Analysis C Query subreport]![Text14],0)" within the actual report. Neither one seemed to work.

I have a main report with 3 subreports included. I want to total one field in all three reports to give a Grand Total of the Values. The problem is, that not all three subreports will always have a value in this filed due to no matching data from the table. How can I add these fields...