I'm just wondering how to go about summarising data from across different forms.
If, as an example, I had a form recording sales and I had another form recording expenses, would I be able to summarise that data on another form to show sales, costs and profit totals for a specified period on another form?
In a related question, as far as I can see a report can only work on a single form type at a time. Is that correct?
I believe your correct about 1 form per report but you might be able to pull in other data with related fields, query calculations (see appearence tab in query designer) and global variables. Maybe run your query for a certain period and use this query to set a calculated sum field. Then transfer to a global which can be used almost anywhere. Repeat for all other forms needed in report.