Reference One Report From Another?

[SteveF]

I don't quite know where to ask this question, but, as always, any help appreciated and my apologies if it's in the wrong place.

I have a form which runs a query for me to work out the diference between two dates, so an opening date and a closing date = a number (of days)

I want to use that number in other places as well and I'm struggling. I don't seem to be able to use it in a query, so I'm wondering if I can reference one report from another.

The results of my other queries are outputted as reports and they are all used as sub-repors on the one page. So I have my number of days, I can see it, but can I use it?

Hope this makes sense.....

 

[ajetrumpet]

yes you can. to reference a form to a report, you have to have both open. Just use the syntax:

forms!formname!controlname

 

[SteveF]

Thanks for replies, I will try both of these this morning.