Recent content by marwan211

I have the following statement in the details of a report. =IIf([Text66]=0 And [Text58]=0,[atrucka royalty]*1,IIf([Text66]=0 And [Text58]=1 And [text86]=3,[atrucka royalty]*0.2,IIf([Text66]=1 And [Text58]=0,[atrucka royalty]*1,IIf([Text66]=1 And [Text58]=1,[atrucka...

I have a report that is grouped by state. In the details of each state I have customers. However, when i run the report the same customer is listed several times because there are that many line items for the customer. How can I get the report to sum the customer if the name is the same. goal...

I am a newbie to the forum but have worked with Access before. This formula is complicated (to me at least) and I would greatly appreciate some help. Here we go. Field2: LICENSEA Field3: LICENSEB Field4: FEE Field5: STATE Field6: FEDERAL Here is a word version of how I would like the formula...