Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: Problem with a query for a report

    I want to show fields on a report with the field is not equal to zero e.g.

    my query has the following rows
    headings: customer amount1 amount2
    details: cust1 $200.00 $0.00
    cust2 $50.00 $100.00
    cust3 $0.00 $0.00

    I don't want the fields with the zero amounts to show on my report. Each customer is displayed on a different page of the report.

    Please Help!!!!!

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Select * From tblMyTable Where Amount1 <> 0 And Amount2 <> 0;

    Use this query as a datasource for your report.

Posting Permissions

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