Recent content by morning1001

...in regards to item #2 right click on the detail section while in the report design select properties select the "format" tab "Force New Page" should be set no "None"

I figured it out... If [Single Family] = 90 Then If [Duplex] = 10 Then If [Apartments] = 20 Then [Single Family].ForeColor = 16711680 [Duplex].ForeColor = 16711680 [Apartments].ForeColor = 16711680 Else [Single...

Is it possible to have an iif statement build upon multiple conditions? I would liketo change the formatting of the report when three conditions are met...

I have a table displaying all records. There is a comments field for modified records (e.g new, amended, or deleted). This way all edits are retained in the table. In my report I have totaled each records amount in the group header. My problem is the deleted records are included in the...

Goto Sorting and Grouping. Specify Brand and Group (each only once) in the field/expression area of the table. Below the table select "yes" for both Group Header and Group Footer for both Brand and Group. This will show your group footer below the brand footer and not show the duplicated...

Place the text boxes you want to display totals in the report header of the report. If your field name is "field" type "=sum[field]" in the text box. You can either leave the rest of the report blank or show the details in a header or the detail sections of the report. Hope this helps...

How many fields can be used in a report created through the report wizard? Apparently 41 fields is too many... If I dont use the report wizard, is there still a field limitation? Thanks