Layout issue in access reports

  • Thread starter Thread starter Jeroen Verdrengh
  • Start date Start date
J

Jeroen Verdrengh

Hi,

I have a report showing all visits in my DB and for each visit I have a
group of reletad VAT tariffs that are shown below each visit. The problem
is that not all visits are related to one or more VAT tariffs. Here is,
simplified, the querytable I use for the report:

[Visit Object ID] [VAT Tariff (%)][Info related to VAT Tariff]
1 0.20 blahblah
2 NULL NULL

Is it possible to ignore header/detail/footer of a grouping attribute (VAT
Tariff in this case) if the attribute is null? Now the labels are shown and
that's far from clear. With IIf(..) I can hide the labels when VAT Tariff
is null, but then there is blank space left...

thanks!

Une-V
 
Back
Top