Access Report

[bigdfia]

I am creating a report with a header and detail. The problem I am having is the header is a total of the detail but sometimes I only have one line of detail so it just repeats the data again. is there a way to hide the detail if there is only one line of data for the header?

[nico5038]

I would hide the header by adding a test for the number of records (e.g. by using the recordsetclone property) and when 1 set the header fields to visible = no.

Nic;o)

[bigdfia]

Yeah I wrote some code that took care of it. If anyone wants to see it I have it.