Search results

thanks for the input...I have changed the summig and all appears well...I will look into keys and normalization...your input has been incredible and educational.... Best Regards...:)

Thanks for all the Help, figured out the subtotaling and totaling...I have attached the file for your review and final comments...take a look at my final report if you would... Once again...thanks...:>)

Nice...built the query to run the report from excluding Tax trans type... In this statement - =Sum([total])+Nz(DSum("[total]","qryReportDetails","[fullname] = '" & [FullName] & "' AND [InsName] = '" & [InsName] & "' AND [transtype] = 'Tax'"),0)... please explain the NZ(DSUM... looks like...

I am running 2007...:( Do I have to do anything to invoke the event procedure other that put it on the ON FORMAT Line?

I see the TRIM was changed...what does the LCASE function do? I still see Tax lines on Page 6 though? Do you have them in yours on page 6?

Attached is the database...once you get it running...page 6 is a good place to check for Tax lines... Thanks for look at this for me....

The control on the field is TransType...made the change... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Trim(UCase(Me!TransType)) = "Tax" Then Me.FullName.Visible = False Me.TransType.Visible = False Me.TransDate.Visible = False...

OK changed Detail Property ON FORMAT TO Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me!TransType = "Tax" Then Me.TransType.Visible = False Me.TransDate.Visible = False Me.Quantity.Visible = False Me.ItemID.Visible = False Me.ItemName.Visible...

If you look at the JPG you can see the detail line has 7 fields...I would have to suppress all 7? is there an alternate way of not printing the tax lines?

Tryied with the Me!Tax instead of Me.Tax...same results... I do not want the detail line to print if the tax is not = zero...therefore suppressing any line with tax on it...I will still sum the tax to be totaled after each group... does it make sense to you...

Thanks for the help so far...I am learning... Here is what I have in the ON FORMAT of the Detail Property Sheet as an Event Procedure... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Tax <> 0 Then Me.Visible = False Else Me.Visible = True End If...

Not a VB guy , tried this but nothing happened... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Tax <> 0 Then Visible = False End Sub Any suggestions...

Not a VB guy but tried this and nothing happened... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Tax <> 0 Then Visible = False End Sub Any suggesions

Hello, I need to suppress printing detail lines with a certain transaction type...I have TAX transactions I do not want to print but I will still total them...any help would be appreciated