can this be done ?

Main report holds the information required - but in the sub report (of which there could be 10 of) I want the data from the main report

the report is split by currency then tax
and then up to 10 sub reprots off this (per currency per tax)

You can certainly reference a field in the parent report from the subreport. Depends on how things are setup though?

Maybe this link will help:

http://www.mvps.org/access/forms/frm0031.htm

Follow the "Not in these forms" section

I'll read this - as doing the other way would be a real nightmare -
each report can have upto 10 sub's

and when I run the main report it should divide into 5-6 reports with x sub reports

thansk for the response

g

Just remember - Sub reports are loaded before the main report, so basing something from the sub report on the main report may be problematic.

Good point Bob. Maybe the OP could explore a different approach, probably using GROUPING where possible.

Just remember - Sub reports are loaded before the main report, so basing something from the sub report on the main report may be problematic.



Bugger...

I will look at this if it works all well and good

Nope - stuffed going down this route -

Any ideas to run two seperate reports

my main report will filter (group by)
currency - I have currrency table with autonumbers on it and a tax table.

I don't follow. Could you elaborate? Surely if you have the Link fields setup correctly it will filter but you obviously know that.

it was late when I typed this last night ....

i think I know what I want and how to do it - so i will muddle through (until i get stuck )

See how it goes. Good luck!