Clearing empty fields + moving others

[Grezzo]

I have a report that has a table layout, one column puts a description of work done, and another puts the price charged, there are 10 rows

I want all the rows that are empty to be invisible and everything below tose rows (sub-total, VAT, total) shifted up.

I may be able to do this in VB, as i can do some programming (a bit rusty tho), but is there any easy way to do this?

Cheers

GR

 

[Crilen007]

in the query just tell it in the criteria

<>0 and not null

then anything 0 or null (empty) wont be in the report.