Perhaps I should answer my own silly question.

A: With the 'Page Break' cmd from the toolbox of course!

Thx for all the help on this one over multiple threads, solved by adding 'set dateformat dmy' to sp and passing date values into sp as varchar(10) then performing a...

didn't do anything unfortunately, problem seems to be when access passes sp date in format dd/mm/yyyy when it is expecting it in the format mm/dd/yyyy, which is why it gets...

pereke, thanks for the suggestion, unfortunately it wont solve the problem as the resultsets returned are of different lengths thus the UNION operator will not work.  Have a feeling I...

I working with ADO, I'm using an Access project with a SQL server database.

Thanks Noel, your a legend.

Remi,

Thanks for your much needed help, how do I keep the form open while the report is executing the SP so it is able to pass the parameters?

noeld, thanks for your very informative reply, as you guessed I'm coming from a procedural background and still trying to get my head around control structures VS sets.  Have revised...