Results 1 to 3 of 3

Thread: logical field

  1. #1
    Join Date
    Sep 2003

    Unanswered: logical field

    hi everyone,

    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 ?

    Thank you for your attention.

  2. #2
    Join Date
    Sep 2003


    You could attach your report to a query and in the query omit all canceled records.

    You could create a calculated field which
    Order Value where (Oder Value = IIF ( Order Status = Cancelled, 0, Order Field Value). And create a summary on that field in your report.

    finally you can write code which Sums the values only iif The Order status is not Cancelled.

    Those are not the only three alternatives but are the quickest which come to mind. The last code needs some object pal experience the others are easy.

  3. #3
    Join Date
    Sep 2003
    Thank you very much for your reply. I will study more on the procedures you have suggested. It is not easy to understand for me but I will try. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts