Generating reports based on values

[iamdamien]

Hi,
I am trying to generate a set of reports, which show the payments made to a particular payee, and the VAT paid. Each payment has a particular description, and the table has a category for each type. Eg. Phone bill, sub contractor, misc. Then a general gross payment and VAT. I want to print reports for only those that have payments to each category. I think an if statement checking whether the value in each category is above 0 before listing those that are is the way I want to do it. But as a relative novice with access, I am unsure how to go about this.
i do hope to eventually print reports based on month of payment too, but i will get to that later within the week.
Any help is appreciated.
thanks.
D.

 

[CBrighton]

What you need to do is build a query which returns the payments you want, then use that instead of the table to feed the report.

Create a query and try some things. If you want the value to be greater than 0 for a field then just input the criteria as ">0". Each row of criteria is together so if you put ">0" for all of them in the same row it will only return payments greater than zero in all fields. If you were to do it in a different row each time it would look for any of the criteria (i.e. it will return every payment which has at least one field greater than zero).

 

[iamdamien]

Right I shall try that. Would that method not print options that have a value of 0 though regardless?
Thanks.

 

[CBrighton]

">" is greater than.
">=" is greater than or equal to.

 

[iamdamien]

Yeah it worked a treat. Thanks very much. As for the >0 >=0, I did ask a very daft question! I realised after I read again!