Perhaps anybody can help me with this question. I use paradox 10 to run my company billings such as issuing, printing, as well as making reports. I need to make a summary report of my periodical sales. I could manage to get a sum amount of the whole billings in the report. However, my question is, there are some cancelled billings in the table and I do not know how to omit those transactions in my report. If I were to delete those cancelled bills, yes I will come up with a true net sales in the summary report. But I need to keep those transactions as reference.
I would be very grateful to any of your help on this issue. Could it be setting the amount in a cancelled bill as false so the counting will omit it ?