I have a report that is based solely on an SQL statement in the record source. It is very efficient - however, there are certain needs that need to be addressed for one particular customer.
In the report there is a number of calculated fields that produce the total price of each number of items, and an invoice total. there is a textbox control that displays a customer number. it is designated as field79 in the property sheet with a control source of TrxCust. there are several hidden textbox controls that calculate the invoice total. They are as follows
- Field 102
l:","") with one adjacent to that named "InvoiceTotal"
What I need to do is ad $20.00 to the InvoiceTotal when the field79 "TrxCust" is 27. There is no designated format for field 79 - so I cannot tell you if it is number or text - and Decimal places is set to Auto
I have tried different variations of code in the On Load property Like
If Me.Field79.Value = 27 Then
Me.InvoiceTotal.Value = InvoiceTotal + Text127.Value
With and without Value added - and I am lost - I've attached the SQL code that pulls the info for this Invoice report
Any help would be greatly appreciated