Empty Space Problem

[Paul Purvis]

I have created a simple report showing what electrical tools need to be tested (date dependant) I have marked to show only uniques, however the print has gaps between each item, as if the hidden lines were still being catered for? which means I have 34 pages instead of 2! /-- best regards Paul

 

[Rich]

Set the can shrink properties to yes

 

[Paul Purvis]

Mmmmm, tried that (and the detail) still got the same problem

 

[neileg]

Have you tried setting the Unique property in the underlying query instead of the report?

 

[Paul Purvis]

neileg, many thanks, however its still displaying the gaps!

I have had a another look at the query that I am doing, I have
Toolid | Make | Model | Lasttestdate |

in the Lasttestdate i have <=DateAdd("m",-3,Date())

the tools get tested on a regular basis, so it is pulling the previous dates as well!

regards Paul

 

[Rich]

>=DateAdd("m",-3,Date())

 

[Paul Purvis]

Ok Folks, Sorted! gues who was using the wrong table to do the query! many thanks, I know it does not give an answer to the original prob, but I now have a usable list. Many thanks for the assistance!

/---Paul

 

[neileg]

It not clear if you have solved your problem or not!

I would use a totals query and use Max on the date to extract only the latest date.

You need to sort this out in the query, not the report.