I'm sure i'm just being a bit of an idiot... but I go to a report design view and have all my data as I want, click on print preview using a macro and get all the data I want, but where the report / print preview should only be 2 pages worth... I get 6 - the 2 pages repeated 3 times which means I have to print 6 pages...
I can't find what I am doing wrong and it's starting to do my head in!
Any ideas...?
Thanks in advance.