Results 1 to 3 of 3

Thread: logical field

  1. #1
    Join Date
    Sep 2003
    Posts
    2

    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
    Location
    Dallas
    Posts
    182

    Smile

    HI,
    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
    Posts
    2
    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
  •