How to make a report to show only value greater than O

[Erictsang]

Dear all



I have a sales report, recorded sales of the month for a customer

I have a queries to filtered the date range

But each customer may have different purchase items.
How can i list only the field that has record?

Client | Item 1 | Item 2 | Item 3

Eric | 1 | 0 | 3
Bertha | 0 | 2 |1
Paul | 2 |0 |0

can anyone help me out, as in actual list there are around 48 items

Eric

[ranman256]

make the query do it.
If you only want people with fields > 0, set the criteria in the query.

[Erictsang]

i should place on the Criteria or Or

As when i place the 1st one on Criteria and the rest on Or

it won't work

[aytee111]

If that is the structure of the table then you are going to have problems. There should be two tables, one for Clients and one for Items.

[Erictsang]

Aytee

Please find my file

[June7]

You say the db is for monthly sales - yet there is no monetary sales data, only what looks like conference attendance.

The query is doing what it is designed to - just not what you think it should. You really need to redesign data structure. If each record can be only one or the other country and can have only one Pass field with data, then there should be only 1 country field and 1 pass field. Country field would have A or B value. Pass field would have maybe date of graduation?