Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    226

    Unanswered: Summarising from across forms

    Hi,

    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?

    Cheers

    Matty

  2. #2
    Join Date
    Sep 2011
    Location
    Australia
    Posts
    264
    Provided Answers: 2
    Hi Matty
    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.
    Regards
    David

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •