Spiderdan1016
Technical User
I have a report that i run every morning. The report breaksdown the sales for the day by username and type of sale. each sale can also be either an order,type O, credit, type C, or return, type R. I need to add some VBA to the report that when a line is a type C or type R the qty shipped and price is multiplied by -1 to make it negative. any ideas. i have experience in programming just havent used VBA in so long forgot the syntax