frustration!!!

[Pharcyde]

I'm trying to get a report done but am stuck because i get the 'your report goes over the margins/boundaries etc etc' message.

I'm putting all the data in the footer because i only want it to appear 1nce. I tried a page break but that doesnt work (maybe cos it's in the footer) and now I'm stuck!

Can anyone help please!?!?!

Lee

 

[Hayley Baxter]

Have you tried puting it in the detail section and setting the Hide Duplicates to Yes, is that maybe an option?

 

[Pharcyde]

sounds goo, where's the hide duplicates thing??

 

[Hayley Baxter]

In the properties of your fieldname

 

[Pharcyde]

ta very much. how i got a job doing access i'll never understand!